I have an Access database that I created in Access 2003, using the Access 2000 file format. I use this to print address labels.
I have a table of names addresses and phone numbers.
One of the table’s fields is a check box that is used by a query to select the records that I want to print on the labels.
I have a report that runs against this query that prints the selected (checked) records onto the address labels.
I have been using this database for years and it worked flawlessly, that is until I bought Office 2007.
When running this database in Access 2007, if I check the checkbox of a different record in the table, and then run the report, the record does not show up in the report. I can go back into the table and see that the record is still checked.
However, if I close the database, re-open it and run the report the newly checked record is there. I never had to do this before, am I missing something? Anyone have any ideas?