Missing Records

[smileychickie]

Ok, when I do a filter by form search for a specific record it doesn't show the record but the record is in my main table. The record is also missing from a sub form. Why is this happening and can I fix it?? Please Help-my database is rather large and I would hate to have to start over!!!

 

[petermeachem]

Well, it's obviously because your filter is wrong. (I mean if it is in the table, and you can't see it when you filter and you should be able to, the filter must be wrong)

Apart from that, we would need a bit more info

 

[smileychickie]

Ok, the filter isn't wrong. I'm filtering by street name and have never had a problem before. If I open a form there are records missing in the form that are in the main table. I have changed nothing as far as the criteria for what appears in the form or a query since the database was created and it always worked before.

 

[scking]

This will require that you do a little troubleshooting. Investigate the form RecordSource to see what exactly is being used to fill the form with data. Then open the code for the form and search for 'RecordSource' to verify nothing modifies the recordsource property for the form during runtime. If the RecordSourse is a query then run the query and verify whether all records are present. If all records are present then check out the filter assignment and trigger assuming the filter you mentioned is set up in code and not a QueryByExample or some other type.

Me.Filter = "id=" & 1
Me.FilterOn = True


If you still haven't found it then go into the debugger and set a breakpoint where the filter is assigned. When you run it check to verify it says what you expected.

And on until found.

Steve King

Professional growth follows a healthy professional curiosity

 

[smileychickie]

Ok, I checked the recordsource and that was right and I ran the query but not all the records were present in the query. The query has not changed since it was created so I have no idea what has happened here. Please help!