New records don't appear in report

[gsc_81]

I have a report (based on a query) that will display all fields from previous table records but will not display any new records. The table has the appropriate data in it and displays the data on the form. When the report query is run the new records do not show up. There is no field criteria specified in the query so all records should show. This just started happening. Everything has worked properly prior to this. Any suggestions? I am perplexed once again.
Thanks.

 

[Pat Hartman]

I believe that I posted this answer 3 times yesterday. You MUST save the current record before you open the report. The report gets its data from the table, not the open form. If you haven't saved the record, it isn't there.

DoCmd.RunCommand acCmdSaveRecord

 

[gsc_81]

it was saved

the record had been saved. actually it is a few records at the end of the table. The info shows fine in the table but is somehow being filtered out of the query even though nothing in the query should be blocking this info.

It appears that the table structure somehow was corrupted. I used a older copy and updated the data and things are working fine now.

Thanks for your thoughts.