Form won't recognize newest records

[oduamy]

Before I ask my question - I have to say THANKS for all of the wonderful information and help this forum has provided me!!! You are all invaluable. Also, I posted this on the Microsoft forum as well - so if you haunt both, I apologize for the duplication!

Here's the problem/question:

I can't figure this out for the life of me. I have a form that is built on a basic query (no filters or definitions or parameters) that grabs fields from a few tables. I have 600+ records and it has been working fine.

This form called frmMainInfo can be called from one button as data entry to enter a new project. It is also used on a different button/screen to find a project and open the record for the project. For 95% of the records it works fine.

I have a handful of records that are the most recently added - I can see them in the table, but when I go to view them in the form - the form is completely blank. I read the KB article and tinkered with a few different things, but I dont think there is anything wrong with my form since you can see the majority of the records. It's just the new ones that are giving me a problem. And it doesnt matter if these new records are added by the form or straight into the table.

When I open the form from the button that operates as acFormReadOnly, the screen is completely blank (no text boxes, title, close button, NOTHING). When I open as an editable form, it shows the form with all of the boxes, but just no data. The last weird thing is when I open frmMainInfo to scroll all records, those records don't appear AT ALL. Not even as a blank hole where that AutoID # should appear for that record.

Im going nuts!!! Can anyone help me sort this out?? I'm going to have a few angry engineers on my back if I cant solve it :)

THANKS!!
Amy

[matthooper]

have you tried having a button that requeries?

[form_name].requery

[oduamy]

No, I haven't tried that. These records don't even appear after the db is closed and reopened.

And I have now discovered that they don't appear in the query at all - even though I have nothing telling the query to exclude them. THe confusion thickens!!

have you tried having a button that requeries?

[form_name].requery

[matthooper]

whats the SQL you are using to submit data to the table and whats the sql/filter your using for the form, whats the table format?

[MMcCarthy]

Also can you tell us how you are adding the data to the tables. You say the data in in all the related tables. Are all the primary and foreign keys correctly relating?

Mary