My form opens blank Why

[Jon123]

I have data in the table and when I manually run my query it returns a table with data. But when I open the form it's blank? I can't figure out why

Please help

 

[pbaldy]

What's the Data Entry property of the form?

 

[Jon123]

I have tried it set to Yes and no either way same results

 

[pbaldy]

The form is based on the query? If you open it from the nav pane it opens blank? Is there any code or macro running on open or load? Can you post the db here?

 

[missinglinq]

...when I open the form it's blank...

To be clear about the term 'blank;' does the Form simply display no data, or does nothing display, not even the Controls?

Linq ;0)>

 

[Jon123]

Well it's funny you ask that question. It was opening the form with the fields and no data entered. Now it's opening the form competely blank. I believe I have an issue with the tables that the query is using to open the form. Still struggling have not given up just yet.

 

[pbaldy]

Completely blank would indicate that the form's record source returns no records and doesn't allow new records.

 

[Jon123]

So if I run the query and I get 1 record in the query grid. Than that would mean the query is good and working. The control source for the form is set to the query. I have removed all the code in the open event and on load events so the form should open and display the data right? Mine does not I get a form with fields but no data. I can enter a new record but I want to display the current data

 

[pbaldy]

And the Data Entry property is No?

 

[Jon123]

Correct. It is set no

 

[pbaldy]

Can you post the db here?

 

[Jon123]

I think I got. I believe my relationships were setup wrong between the 3 tables. But don't get why the qry would return the correct date but not the form.

But I believe it's now working. Thank you for assisting

Jon