Hi,

Any help with this would be appreciated. (Access2000)

I have a form with command buttons linked to another form which when clicked
creates a record in the new forms linked table with some of the 1st forms
info. The user then fills in any remaining info on 2nd form as necessary.

My problem is this;
A record for this instance may already exist and I just need to let the user
know that one exists before they continue. It is rare that another record
may be needed but it is possible. So I will have a msgbox with yes to
continue to 2nd form or no and continue with 1st form.

Could someone please post some simple code that will show me how to search a
table and how I generate a true or false if found or not?

Thanks in advance