query with drop down box

[kabir_hussein]

hi

i am trying to a query where i can view using a report all items matched by what i type in

however what i am trying to do is have a report linked to a query where when the msg box appears, instead of the user typing in the item they can select from a drop down box.

i am not entirely sure how that can be done but i am pretty sure it should not behard enough

many thanks in advance

 

[Mile-O]

Was I not clear enough in this thread?

 

[kabir_hussein]

Hi you were clear enough i just wanted to find out if anyone else any ideas on doing it an easier way as i am not very good at VB codes so i try to avoid them as much as possible


i do use VB for my database when i really have to other wise i try find easier solutions

you mentioned some code on a button referncing the from, how would i do that

thank you

 

[Rich]

Hi you were clear enough i just wanted to find out if anyone else any ideas on doing it an easier way as i am not very good at VB codes so i try to avoid them as much as possible


i do use VB for my database when i really have to other wise i try find easier solutions

you mentioned some code on a button referncing the from, how would i do that

thank you

There is no vb code involved, the wizards and code builders will do the work for you

 

[kabir_hussein]

Sorry what do u mean the wizard and code builer will do the work for me, i have been trying to do this but to no avail

At present my report if you click on it it brings up a list of all items in the table PARTS but what i want it to do is depending on what i choose on the drop down box i want the report to show everything on that item

sorry if im confusing you its quite hard to explain in writing

thank you

 

[Rich]

The Form wizard will create the blank form for you, drag the combo box off the toolbox, the wizard will create the combo query for you to select the value you want, the button wizard will create the button to open the report. In the criteria section of your reports query use the code builder to add the reference to the form/combo you have just created.
HTH

 

[kabir_hussein]

hi thank you for all the help, i have been doing what you said and so far when i select the item and then click on the button to open the report it appears blank

the code i have put into the query linking the report is

[Forms]![project query]![Combo2] = [Reports]![totaltender]![ProjectID]

what happens is the query automatically selects the [Forms]![project query]![Combo2] as a field

do you know what i am doing wrong

thank you once again

 

[Rich]

Remove = [Reports]![totaltender]![ProjectID]

[Forms]![project query]![Combo2] belongs in the criteria section of the field you're trying to restrict

 

[kabir_hussein]

many thanks Rich

hi Rich

i have finally solved my problem, just wanted to say thanks alot for all your help