How do you put a combo box in an Access 2007 Report so you can select a record ID and it will bring up the record in the report so it can be printed?
A:
What you would normally do is create a small form that can be used to open the report. In Access 2007, you can take advantage of the Where argument of the OpenReport method.
On the form you might have a button with some code:
DoCmd.OpenReport "TheReport", , , "NumericID=" & Me.ComboBox
Remou
2010-03-04 23:45:19