Auto Lookup and results

  • Thread starter Thread starter Kirsty
  • Start date Start date
K

Kirsty

Hi everyone

I need some help with something that should be simple
(and most probably is).

I have one table with the telephone numbers and details
of my clients. The table is indexed(no duplicates) on
the tel# field.

My problem:
As I enter a new client, I want the form to autofill if
the record exists and call up the client info, and if it
does not exist then call up a blank record and at the
same time insert the new tel# in the correct field.

Please help.
Kirsty.
 
By "autofill" I assume you mean display an existing record in your form.
Look at the combo-box wizard and use the "find specific data to display"
option. It will create code in the AfterUpdate event of the combo-box that
you can use to find existing records. In the NotinList event of that same
combo-box control you could add code like:
DoCmd.OpenForm "myForm",Add
to put a blank form on the screen for data entry.
-Ed
 
Back
Top