Need a report...

[AccessNewb]

Ok, HERE GOES

I need a report created. The report is going to contain all attributes of one record from a query I have made.
I would like to achieve this by having a drop down list on a form.
Now, how can I do this?
I have a drop down list(Combo box) and I can chose a record from the query. BUT, what do I need to do to relate this to the report? Once I have an ID selected from the Combo box, do i need to create a command button? What do I have to do to the command button to get it to accept the chosen ID and then get it from the query and then display it to the report?

Hope this reads ok
Thanks inadvanced

BTW, I need help quickly

 

[Rob.Mills]

Well you need the combobox bound to the unique key in the record. Then use the docmd.openreport in the command button with a where clause that references the combobox.

 

[AccessNewb]

could you give and example of the syntax for the WHERE clause in the docmd.openreport?


Thanks

 

[Rob.Mills]

DoCmd.OpenReport "ReportName", , ,"[UniqueID]=" & Me!ComboBoxName

That will work if the unique id is an integer. If it's not use this:

"[UniqueID]=" & "'" & Me!ComboBoxName & "'"

 

[AccessNewb]

could you give and example of the syntax for the WHERE clause in the docmd.openreport?


Thanks

 

[Rob.Mills]

Was this a mistake that your last two posts were the same?

I gave an example.

 

[AccessNewb]

Yeah, my systems was frozen so I hit refresh and I gues that did it. SORRY

Thanks for the example

 

[AccessNewb]

That worked great!
Lets see, about 15 hours to get this to report properly.
HMMM,

Thanks again.