Add Customer Info to an existing form

[Sam Work]

Please help a little stuck

I have:
Table 'tblCustomers' - Customer delivery details
Form 'frmOrders' - Product details

Within the frmOrders I need to enter the customer code (from tblCustomers)
so that it automatically calls up the rest of the information from that table.
Is the best way of going about this by using the subform function?

 

[Rick B]

This was answered twice in different posts yesterday. Please do a search.
No need for us to retype when the answer is out there for you.

Rick B

microsoft.public.access.forms Re: VB Code to Auto fill in combo boxes

microsoft.public.access.forms Auto Update a value in a field based on
another?

 

[AlCamp]

Sam,
If you have a lot of fields to display, using a subform of customer data
linked to the main form by CustID would be a good way to go. Use a combo
box to facilitate choosing a CustID

If you just have a few fields to show, you could use a combo with CustID
and any associated data in the columns. Then, an unbound text control could
be used to display the information in the combo columns.
For example, if the 3rd column contains CustCity, then a text control
with...
=cboCustID.Column(2)
would display the customer city. (Combo columns are numbered 0,1,2,3 etc)
hth
Al Camp

 

[Sam Work]

Thank you so much for your help.

This was answered twice in different posts yesterday. Please do a search.
No need for us to retype when the answer is out there for you.

Rick B

microsoft.public.access.forms Re: VB Code to Auto fill in combo boxes

microsoft.public.access.forms Auto Update a value in a field based on
another?