query with vb code urgent

[kabir_hussein]

Hi

I am trying to do a report linked to a query using a drop down box(as i want users to select what item they want to view not type in what they want) however i have been advised that this is not possible.


Instead I have to do a form wher i use a drop down box from the form and make a buton with some code in it referecning it to the report and form.

In theory i want to select an item from the drop down box and when i click on the button i want it to show all data on that item on a report.

however the problem lies in that i am not very good at VB code, and was hoping someone could help me with this

many thanks in advance

 

[Rich]

Do you not read your replies to your other posts on the subject, again there doesn't need to be any vb code. Although the Where clause of the OpenReport method is preferable

 

[kabir_hussein]

sory got your msg after i sent this out