How can i Populate combobox based on value from first combobox from another table

[MurtazaKhambaty]

Hello

I have a table name Product

1.ProductCode
2. ProductName

Product Sub Table

1.ProductCode
2.ProductGrade

The ProductCode are same forexample there is one Product named ABC and its code is 001
This Product has 3 different grades i.e

001 ABC 123
001 ABC 456
001 ABC 789

Now i want that when i select ABC the other combobox should only populate values 123, 456 and 789

How can i achieve this??

[zmbd]

THis is basically the same concepts as covered here:

• Cascaded Form Filtering
• Multiple Combobox Filter with Clear Option

Keep in mind that the ROW SOURCE is NOT the same as the CONTROL SOURCE. The Bound column is the value that the control will return; thus, the bound column must be for a value that is legal in for the control source.

We can help you with the code/equations once you have them setup; however, we do not usually provide completed code.