Lets see if I can make this clear. I have 2 tables, one table (tblContacts) has information on contacts....Name, address,Phone, etc. the other table has information on meetings (tblMeetings). This table has information to the meetings...date, time, name(from tblcontacts), objectives, issues, etc. For each meeting, I will have several entries for the same meeting (one for each client present). the reason to have a separate entry for each client per meeting is that each meeting will have different clients and each client will have different data for each meeting.
Now the Issues begin.
Issue 1: I have a form for data entry. In the form it has two combo boxes (cmbMeeting and cmbName) and several text boxes that have the relevant data. The form has to be populated based on meeting the criteria of both combo boxes. The cmbMeeting is populated from a query (qryDistinctMeeting)to get only the distinct meeting dates. The cmbName is populated from a query (qryNamebyMeeting)that gets all the records that have the Meeting date (from the form cmbMeeting). What I need to do is populate the form from selecting a name in cmbName. I can do it by setting the text attribute of each text box separately based on the column of the cmbName. This works, but I am not sure how to accomplish Issue #2. Is there a simplier way to do this?
Issue 2: I want to change information in the text boxes and have this update the appropriate tables.
Issue 3: I want to do a NotInList for both combo boxes that will add a new record if new information is entered.
Now the Issues begin.
Issue 1: I have a form for data entry. In the form it has two combo boxes (cmbMeeting and cmbName) and several text boxes that have the relevant data. The form has to be populated based on meeting the criteria of both combo boxes. The cmbMeeting is populated from a query (qryDistinctMeeting)to get only the distinct meeting dates. The cmbName is populated from a query (qryNamebyMeeting)that gets all the records that have the Meeting date (from the form cmbMeeting). What I need to do is populate the form from selecting a name in cmbName. I can do it by setting the text attribute of each text box separately based on the column of the cmbName. This works, but I am not sure how to accomplish Issue #2. Is there a simplier way to do this?
Issue 2: I want to change information in the text boxes and have this update the appropriate tables.
Issue 3: I want to do a NotInList for both combo boxes that will add a new record if new information is entered.