cclark9589
Registered User.
- Local time
- , 20:34
- Joined
- Sep 22, 2008
- Messages
- 79
Access 2007
Fairly certain I have seen the answer to my question in this forum before but I sure haven't had any luck finding the solution. My apologies in advance for having to ask this question.
I have a database that serves two purposes:
frm_Attendance is used to enter the names of those who show up for the clinics and has but 3 fields: Full Name, League/Dist and Clinic Year.
Full Name is a combo box using qry_Names.
League/Dist uses dlookup to return the league/dist name from qry_Names.
Clinic Year uses =Year(Now()) as the default value.
If a name isn't in the list of Full Names, I want a msg box to appear stating that name isn't in the list and when "Ok" is clicked, frm_Names will open (modal? Popup?) so that the information for someone new can then be added to tbl_Names using frm_Names. Once frm_Names is closed I want to return to frm_Attendance.
Does any of this make sense? How do I do this and where do I place the code?
Please try to remember that I am very dangerous when using Access and can easy inflict pain upon myself i.e., please try to reply in plain simple English that even I can understand.
Thanks so much in advance.
Another quick question: any suggestions on how I might frame my search parameters for future reference?
Fairly certain I have seen the answer to my question in this forum before but I sure haven't had any luck finding the solution. My apologies in advance for having to ask this question.
I have a database that serves two purposes:
- Foremost is to build a list of contacts within our district. Nothing fancy; first name, last name, league, email and role.
- Secondly is to record who has attended various clinics conducted by our district.
frm_Attendance is used to enter the names of those who show up for the clinics and has but 3 fields: Full Name, League/Dist and Clinic Year.
Full Name is a combo box using qry_Names.
League/Dist uses dlookup to return the league/dist name from qry_Names.
Clinic Year uses =Year(Now()) as the default value.
If a name isn't in the list of Full Names, I want a msg box to appear stating that name isn't in the list and when "Ok" is clicked, frm_Names will open (modal? Popup?) so that the information for someone new can then be added to tbl_Names using frm_Names. Once frm_Names is closed I want to return to frm_Attendance.
Does any of this make sense? How do I do this and where do I place the code?
Please try to remember that I am very dangerous when using Access and can easy inflict pain upon myself i.e., please try to reply in plain simple English that even I can understand.
Thanks so much in advance.
Another quick question: any suggestions on how I might frame my search parameters for future reference?