Hi all again.
I have one I can't figure out.
I have a form that opens in Add a record mode.
this form has a sub form in it.
it opens and I add a customer name to a field Field name: "CustomerName"
A new record is started, saved as a new customer name.
I need this to also do this on a duplicat "CustomerName" if typed in.
Open the Record in the main form that matches the first matching name.
and start new child records for the existing customer.
the whole form is based on a Query with all the information in it.
any help would be greatly appriciated.