Query doesn't return data

[GingerLM]

Hello,
I created a form and I'm connecting it to 4 tables using Query Builder. When I enter the data into my form, the data goes into the correct tables, but when I go back to the form it's blank and doesn't show any records.

How can I get the query to return the records to the form?

Thanks!
Ginger

 

[pbaldy]

It sounds like the Data Entry property of the form is Yes; you want No.

 

[GingerLM]

Hi Paul,
Thanks for responding so quickly! I checked and the Data Entry is set to No. So not sure what to do...
Thanks,
Ginger

 

[pbaldy]

Is there a criteria on the query? How is the form opened (an argument of OpenForm could override the Data Entry setting)? Does any code run when the form opens? When the form is reopened, what to the record selectors say at the bottom?

 

[GingerLM]

There's no criteria. To open the form I just double click on the form name. I don't think any code is running when the form opens. The bottom just says Record 1 of 1, but I do see the data when I open the tables.

Also, I just ran the query with my 4 tables and it doesn't show any records either. I was thinking of setting the criteria to my primary ID key not equal to "blank" for each table.

 

[pbaldy]

If you can add records through the query, you should be able to view them. Can you post the db?

 

[Johnny Drama]

If your query is pulling data from tables with empty fields, you may need to change the join type.