On form open, new records are blank/invisible until a filter is selected and removed.

[breezett93]

Earlier this week, I completed migrating our data from Access to SQL while still using Access for the front end. Now, we are finding minor issues here and there. After adding a new record, when going to view it, the record is blank. However, if I select a filter and then clear the filter, the missing records are restored. When the form loads, the records are sorted by number desc.

Here is what the form looks like when opened:


And here is what the form looks like after the filter is applied and then cleared:



So the data is making it to the SQL table. I can confirm that in SSMS. So, the issue appears to be in Access, but I don't know what to look for because this hasn't happened before.

Thanks.

[ranman256]

set the form property FILTER ON LOAD= FALSE