I know this is a simple problem but it has bothered me for 2 days now.
I have a work order that once information is entered, should produce the worksheet via report. The problem is that when I run the report, the infomation is blank. However, when I go back a record all the information shows up. then I have to go forward a record and run the report again. It seems like the table is not saving the data before I run the report even though I am creating a temp table before the report runs. I even created a macro to save the table first but that didn't help.
There are no page gaps on the report, the actual information is missing for the current record selected. At first I based my report on a query, with the criteria [forms]![workorder]![ID]. This logical way doesn't work and I don't know what the problem could be.