Form is opening blank

[RexesOperator]

A new problem has cropped up.

My form is opening blank. I have tried compact and repair. I imported everything into a new database. I have checked the query to make sure it has data. I have checked the form's properties to make sure Data Entry is set to No on the main form AND the subforms. I deleted the query and built a new one. I even built a new form form the same query - the new form works. So the problem isn't the query.
The last thing I tried was creating a blank form from the same query and copying the controls on the original form into the new one. Everything works. The question now is why? I added Allen Browne's discussion for anyone else who might have the same problem.

I looked on Google and found Allen Browne's explanation - see below, but this does not seem to apply. The images show the settings I am using. I have attached a stripped version. (Note that although the second image shows the textbox control source as tblTransactions.TransactionsID, the control source is actually from the qryTransactions TransactionsID. I was trying to see if the problem was in the query or the table.)

From Allen Browne:
The Cause
It happens when both these conditions are met:

There are no records to display, I have records in the query
and No new records can be added. New records can be added
Condition (a) can be triggered in several ways. Examples:

The form's Data Entry property is set to Yes. (This means the form shows no existing records, i.e. it is for entering new ones only.)
The form has a Filter applied (or is opened with a WhereCondition) that yields no records.
The form is based on a query where the criteria yield no records.
The form is based on a table that has no records.
Condition (b) can be also be triggered by several things:

The form's Allow Additions property is set to No.
The form's Recordset Type property is set to something other than Dynaset.

 

[Alansidman]

Open your form in design view. Click on Detail and reset it to visible. You have this set to No.

 

[RexesOperator]

Doh! and double doh!

Boy do I feel dumb. Thanks for looking.

That was supposed to be on the tab control. That explains why a new form worked too. I'm glad I posted the stripped version.

Go Red Sox (if it can't be the Jays)

 

[chris11590]

i dont know if this helps but i am still learning and want to help. when my reports were empty is because it had to do with parent and child relationship founded in the properties. the relationship had nothing in common to bring the data to display. good luck.

 

[RexesOperator]

Thanks for the interest - it was the Visible property that was the culprit.

 

[Lrn2Code]

I'm having the same problem with a form opening blank in form view but all the labels, drop down lists, etc. showing up in design view. I don't have a visible option under the form properties list. Why would that be? What other types of issues can cause a form to not display in form view?

Thanks!

I figured it out! The form was running off a query and the query wasn't populating properly so there were no records in it. That made the form blank in form view.

Hope this will help someone else in the future.