Reports Help

[jpartlan]

I'm using Access 200/2002 and need help with reports. Currently I have a form that gets filtered information from a combo box to display the rest of the information. So I have a report button that will print a report based on the record pulled from that combo box. However, I need a report button that will print all my records that I can get from that combo box.
I'm self taught so I lack knowledge of the background programming stuff.

[nico5038]

The basic "trick" is to use a combobox with two columns like:

* , <All>
1234 , ID1234
etc.

The first field needs to be the value you're looking for and the second is displayed.
Now use in the report query:

select ... from tblX
where ID like [forms]![yourformname]![comboboxname]

The LIKE will do the trick with the "*" to select all.

Nic;o)

[NeoPa]

Are you asking for the report to match the ComboBox specifically, or are you asking for the report to match the same list that the ComboBox already matches?
The former is much more fiddly and would not be easy for a newcomer to implement.
If the latter, then more information would be required.