autopopulate form text boxes

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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
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,
>
> Doug
>
>.
>

's Computer Specifications

http://www.mvps.org/access/ Search under Dlookup and it
has a bunch of samples that should be of help...
sam

>-----Original Message-----
>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
>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,
>>
>> Doug
>>
>>.
>>
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
User Form Text Boxes - Copy format of text boxes	NDBC	Microsoft Excel Misc	3	2nd Jul 2009 02:02 AM
Setting an array of text boxes equal to individual form text boxes	lcaretto	Microsoft Excel Programming	6	19th Sep 2008 04:19 PM
Text Entry to Autopopulate	=?Utf-8?B?S2FyaW0=?=	Microsoft Access	1	5th May 2006 05:53 PM
autopopulate parameter value with value from a text box	=?Utf-8?B?VGluYQ==?=	Microsoft Access Queries	4	7th Mar 2006 08:32 PM
Text Box autopopulate		Microsoft Access Form Coding	2	4th Mar 2004 05:00 PM