Dear Users,

I have a doubt at this! I have been to generate a table with a list of products containing the following:

ID
Group (by entering this value, putting 'receivers "or" accessories ")
Description
Unit Value

Next, I generated several tables, filtering by the Group, which resulted in two tables with a list of products relating to the Group "receivers" and other "accessories"

The idea I have right now is to create a sub form to the Budget, which contains a comboBox_Group and other comboBox_Product_Description, a numbox_Quantity and a numbox_Unit_Value:

In the first ComboBox_Group, I will choose the group I want (I may have a default choice for type "receivers" or "Accessories") and after I choose one of these two, automatically the second ComboBox_ProductDescription is filled with products related to the Group.

After choosing the ComboBox_ProductDescription automatically is filled the numbox_ Value Unit (This part I already know how to do)

My point is that, for the first part of the selection, by selecting the first ComboBox_Group, in the second ComboBox_ProductDescription appears automatically the Products Filtered? Is this possible?



My idea was to choose the first comboBox_ group (receivers or accessories) and AfterUpdate create a CASE to choose one of two, and presents in the second comboBox_ProductDescription the Table Query Receivers or the table Query Accessories, Is this possible? and How I make this code?

I hope I made myself understood!