Hi all,
What i want to do is this:-
Enter a unique value (eg Registration No.) into a field and if the value DOES NOT exist continue entering the rest of the vehicle details.
If the value (reg. no.) DOES exist display all the vehicle details for the remaining fields.
Thanks in advance.
Garth.

I do believe that this will happen automatically in a form created with the form wizard, but only provided that the registry number is the primary key or set as Yes(no duplicates) on the indexing field of your table.