how i make a query on combobox selction

[eldarbs]

hey june7.. first - thanks again !!
i tried some things and i succeeded to make the right filtering on those comboboxe by putting this code on the enter event and the exit event :

Me.c_cmb.RowSource = "SELECT Products.ID, Products.[Product Name]FROM [Products Category]INNER JOIN Products ON [Products Category].[Product Category ID]= Products.[Product Category ID] WHERE ((([Products Category].[Product Category ID]) = [Forms]![Order Details singel].[combobox_name]))GROUP BY Products.ID, Products.[Product Name];"
it's works fine on a singel form (and also Prevents from the other rows to change vereytime i fill a new row of bombobox in the singel conuinuius form)
the problem is steel when i do the same on the order details subform - i get an error massage box from access that asking from me to insert the value
instad of taking it from the first combobox like it doing well in the same thing on the single form.
i think that i have a mistake in the referral to the subform in that code that i put on thae same way to the subfrom :

Me.c_cmb.RowSource = "SELECT Products.ID, Products.[Product Name]FROM [Products Category]INNER JOIN Products ON [Products Category].[Product Category ID]= Products.[Product Category ID] WHERE ((([Products Category].[Product Category ID]) = [Form]![Order Details form]![Order Details subform].[combobox_name]))GROUP BY Products.ID, Products.[Product Name];"

please chack the code if this is the way that i should referral RowSource query to a subform.


thanks.

[eldarbs]

hey june7, thanks for all..
i received a refernce from that links that solved my question :

http://www.btabdevelopment.com/ts/refer2sfrms

http://www.btabdevelopment.com/ts/ewtrhtrts

the right way was not putting any queries on the RowSource - also to Prevents from the other rows to change vereytime i fill a new row of bombobox in the singel conuinuius form. and Instead of, just put that code on enter and the exit event of the second CMB and just on the enter event of the last CMB :

Me.Product_ID.RowSource = "SELECT Products.ID, Products.[Product Name]FROM
[Products Category]INNER JOIN Products ON [Products Category].[Product Category
ID]= Products.[Product Category ID] WHERE ((([Products Category].[Product
Category ID]) = Forms![Order Details]![sbfOrderDetails].Form![combobox name]))GROUP BY Products.ID,
Products.[Product Name];"

solved !!