Parameter Query with Combobox?

[Krs13]

Hi,



In Parameter Query criteria we have textbox to enter the value and filter for that particulars. But if we want the Textbox to be an Combobox(which will be one of the table) how to do that.

When i googled it, i found that the combo should be in the form and some code.. what they had given should be put. But when i tried that it didn't work.

Can anybody tell me how to do that for filtering Forms as well as Reports.Thanks.

[Rainlover]

If my assumption is correct and that the Text Box is on the form then do the same thing for the Combo Box.

[Krs13]

If my assumption is correct and that the Text Box is on the form then do the same thing for the Combo Box.

Yes, basically i want to filter the records choosing from Combobox and display records in Forms/Reports.

[Rainlover]

If you can do this with a Text Box you should not have a problem as a Combo Box is simply another control on the Form.

But obviously you are having problems so please explain what you have done and where you believe you are experiencing a problem.