Lookups Based on Table

J

Jim Thomlinson

I have a table called Products. For simplicity it contains 2 fields. Product
and Size. Here is some sample data

Coke 1L
Coke 6x355ml
Coke 2L
Pepsi 1L
Oreos 500g

Here is what I want to do... On a form I want 2 combo Boxes, Product and Size.

If I Select Coke from a unique list of Products then Size displays the
unique sizes associated with Coke. If I Select 500g then I get the list of
unique products that come in that size. Basically linking the combo boxes
based on the valyue of the other... This should be easy but it has been too
many years for me since I did this last.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding duplicate fields in a table 1
Finding the right style field in VBA 0
Link a text box based on drop down box with four options MS Word 365 0
Dynamic Naming of Form Button 3
Lookup a "Closest Match" value in a table 1
Unable to display values in 2nd list box from 1st list box selection 2
Combo Box based on another Combo Box 1
Newbie -Selecting a DISTINCT 2 fields out of 3? 4

Top