Combo Box/Drop Down Box Help

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Hi,

I know this has been answered before but I can't seem to
apply those answers to my situation after 2 days of
attempts

I have 2 combo boxes in a form Client and Category. I
also have a table with Clients and Categories listed. I'd
like to simply have a user select a Client from the drop-
down and then have the Category drop-down pre-populated
with the information that ties into the Client name from
the table. Seems easy, but I'm getting hung up. I looked
at this site http://www.mvps.org/access/forms/frm0028.htm
but it didn't help me too much. My Client drop down only
list Client, not the names, and there is nothing in the
Category drop-down.

Thanks.

Jason
 
The sample in the Access is for narrowing down the selection list. This
requires a One-to-Many relationship between the Table used as the RowSource
for the 1st ComboBox to the 2nd Table used as RowSource in the 2nd ComboBox.

I am not sure from your description but it seems to me that you have them in
reverse. Normally, you select the Category first (for example: Corporate,
Major, Business, Residential) for the first ComboBox and then the 2nd
ComboBox lists the Clients who belongs to the selected Category.
 
Back
Top