autopopulate form text boxes

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I have created a table with my customer list. I want to
enter ni invoices in a form and when I type the customer
number, the name, city, etc automatically populates. Is
this possible?

Thanks muchly,

Doug
 
Yes. Use DLookUp functions (check the Help files for details)

You should also consider a ComboBox for the customer numbers instead of a TextBox. With a ComboBox, you can ensure that only valid CustomerIDs will be entered/selected

----- Doug wrote: ----

I have created a table with my customer list. I want to
enter ni invoices in a form and when I type the customer
number, the name, city, etc automatically populates. Is
this possible

Thanks muchly

Dou
 
I'm using a combo box for the cust number but I have no
idea how to use a dlookup and I can't find anything
useful in the help files.
-----Original Message-----
Yes. Use DLookUp functions (check the Help files for details).

You should also consider a ComboBox for the customer
Click to expand...
numbers instead of a TextBox. With a ComboBox, you can
ensure that only valid CustomerIDs will be
entered/selected.
 
Back
Top