Combo box value depends on the selection of another combo box

[Pettor]

Good morning to All,

I have an "order form" through which I enter data to a table.

There are two combo boxes that are related to each other, one is the "category of a product" and a second one which contains the "products".

When I am placing an order to a customer, first I choose the category of a product and then the product itself from the second field.

I followed this link in order to do it. https://www.youtube.com/watch?v=rdAqkg6bGT0&t=213s

My problem is that although I have entered the values on the second combobox, when I am going back and forth to the records through the form, I see only the category values on the first field and not the product related, although it is normally registered to the table.

When I go to the first box (category) and select again the same category, the registered value of the product appears in the related combobox for all the records that are related with this category, but the products that are connected with all the other categories disappear again to their records until I choose again the "category value" on a given record.

Then all the values related with the selected value appear and the others are lost.

Any thoughts on this?

 

[ranman256]

The query of Products looks at Cata.
select prod from tProds where Cata =forms!myForm!cboCata

then when the user picks the cboCat, you must refresh cboProd to see the pick....

sub cboCata_afterupdate()
CboProd.requery
end sub