Form Not Searchable

[Zanstemic]

I'm hoping this is a simple issue but not sure how to track it down in
Access. I have a form needs to show a specific record and the filter seems to
be correct. During trouble shooting I found that the form does not seem to
have any records associated with it.

The query runs correctly and shows all records. I've also tried to strip it
down to the table but the form will not display the records in the Record
Source.

I've been checking for some kind of lock or limitation but can't seem to
find the settting.

Any suggestions would be greatly appreciated?

 

[Jeanette Cunningham]

Here is one thing to check.
If a form has its Data Entry property set to Yes, it won't show the previous
records. It opens only to accept new data.
You can check this on the property dialog for the form, on the data tab.
If this is set to Yes, change it to No
If Allow Additions is set to Yes, the form will show previous entries and
allow new records to be added.

If the above is not the reason, do a quick test - create a new autoform
using your query. If the autoform shows all records, do a quick test by
using code to open the autoform at the filtered record. If the autoform
performs correctly, copy its settings to your problem form.

Jeanette Cunningham

 

[Zanstemic]

Yes, this helped. Thanks so much.

Turns out that the error was in the query and was not returning a record
that matched the criteria.

Without any records in the query, the form was not searchable because it
lacked data.

By running the query separately, I was able to track down error.