Combo boxes assigned to different tables based on another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For each customer I have a table that lists hundreds of customer codes. I want to use a combo box to select the appropriate code but need to assign the correct customer table to the combo box once the customer name field is entered. How can I have Access assign the correct table or query to the combo box based on the customer selected in a previous field

Any help or suggestion is appreciated.
 
If you are only showing one record on the form at a time,
then you can change the rowsource for the combo box using
VBA code.

If you are showing multiple records, then changing it for
one record will change it for all the records also which
is most likely no what you want. j.
-----Original Message-----
For each customer I have a table that lists hundreds of
Click to expand...
customer codes. I want to use a combo box to select the
appropriate code but need to assign the correct customer
table to the combo box once the customer name field is
entered. How can I have Access assign the correct table
or query to the combo box based on the customer selected
in a previous field?
 
What publication or link can you recommend for learning programing techniques? I have not programmed Access in about 4 years and need to refresh myself with 2003 version.

----- Jennifer Hoyte wrote: ----

If you are only showing one record on the form at a time,
then you can change the rowsource for the combo box using
VBA code

If you are showing multiple records, then changing it for
one record will change it for all the records also which
is most likely no what you want. j
-----Original Message----
For each customer I have a table that lists hundreds of
Click to expand...
customer codes. I want to use a combo box to select the
appropriate code but need to assign the correct customer
table to the combo box once the customer name field is
entered. How can I have Access assign the correct table
or query to the combo box based on the customer selected
in a previous field
 
I usually just go to the Microsoft site. But there are
good books out there too, I've heard.
-----Original Message-----
What publication or link can you recommend for learning
Click to expand...
programing techniques? I have not programmed Access in
about 4 years and need to refresh myself with 2003
version.
 
Back
Top