Check for existing records befoe saving new record

[mckenneyj]

Table has composite key PeopleID Integer & SeminarID Integer
The Form has you select an individual with a combo box bound to peopleid
It then has you select a seminar to attend using another combo box bound to seminarid
On the afterupdate event I need to check and see is any records already in the table have matching people & seminarid and then inform the user "This person is already registered. Would you like to edit their registration?"

Thanks,
John McKenney
Work Hard... Play Harder

 

[hneal98]

You can set up check boxes or text boxes so when a person is selected, their information will be displayed so you can see imediately if they are already signed up for a specific seminar.

 

[Rolliee]

I would input the data in a form that is just like the 'mainform' and check all the data before adding it to the recordset of the mainform. You could also to an after_update event to look in the recordset's clone for the pertinant data.

rollie@bwsys.net