Reports

[jwf]

I have created a form with a combo box. the table is linked to a query. When the end user selects the record in the combo box and hits a button to print the record the print preview brings up a record. unfortunatly it is not the record selected in the combo box. It always brings up the first record in the query. I must be missing a link somewere?

 

[mahenkj2]

You have posted in wrong forum, so you might not get enough replies.

anyway, to go for the record in combo, you have to give reference of this combo in the recordset being opened for print preview (criteria fields in the query), like below:

Forms!FormName.ComboName

here you replace FormaName and Comboname with your actual names.