Check for Existing Records within a form

[Guest]

Using Access 2003
I have a form for Data Entry and Each Customer has a unique Account_ID. This
information is keyed from contracts and not all contracts for the customer
will come in at the same time.
Contract Information is stored in a separate table. Contract Information and
Customer Information are linked by Account_ID
I would like to check for Existing Account_ID and then populate the remaing
fields from that customer record onto the form.

If Account_ID not found a new customer will be added with a unique Account_ID

If found the new contract will be added to Contract Table.

When I type in the Account_ID the existing Contract information populates
but the Customer Information does not appear and I get an error Account_ID
must be unique.

 

[Guest]

Hi Linda G,

If you start with data entry = false, and have a combobox with the AccountID
in, if the record exists, the form should show it correctly without your
error, but if it doesn't exist then you can use the on_not_in_list event to
change the form to data entry, and add new records as you do currently.

TonyT..