how i make a query on combobox selction

[eldarbs]

I have a form with the fields - Category ID Product ID supplier ID. like in the image i attached.
I want to create a query condition that make filtering - once I choosed one of the option in the categories id combobox then in the produacts ID selection box will show selection that only products belonging to the same category that was coosed befor and also for supplier ID combobox will selection of suppliers who provide this product.
I want to know the syntax of the query.
thanx

 

[vbaInet]

It cannot be done in a continuous form or datasheet view because Access wasn't built that way. You can only achieve this easily if the combo box is in a single form.

That said, if there are a few tricks out there you can use to achieve your goal, but they are advanced techniques and I don't think many of us support them. See here (continuous form combo):

http://www.databasedevelopment.co.uk/examples.htm

 

[eldarbs]

wow, bad news..
can you give me an example for a syntax if i will dicide to use asingle form..
that way also i can at least understand the logical of the query.. and mabye a can Continuefrom from that ?

 

[vbaInet]

We've answered this question many times. If you have a search on the forum you will find lots of useful posts on this. Use the Advanced Search feature.