What makes a form go completely blank?

[Margarita]

Hello,
I am in access 2003. I have a form that I have been using for a while:
main form: vendors
child: invoices
grandchild: invoice details

It's been up and functional for weeks. All of a sudden, I open the database to find that when I open the form in form view, it is compeletely blank- only a gray screen appears. In design view, everything is as it should be- all the controls are in place.

I checked the visible property of all the subforms and they are all set to visible.
The allow edits of the main form and the child form is set to No, and the grandchild can be adited.
The main form and child are based directly on tables, not queries. The grandchild is based on a simple updatable select statement query.

When I hover the mouse over the blank gray screen in form view, the record counter at the bottom moves through records- it shows 'record 1 of 28', etc- so it is 'seeing' records (the right number of records, by the way), just not showing them to me.

I did not change or even open the form for a couple of days and did not run any vba that impacts the tables on which the form is based.
Does anyone have any ideas what could have caused the form to open only blank in form view?
Thanks in advance for any input anyone might have on this.

 

[dbay]

I know if you have your Form set to "Allow Additions = No" and you open the Form on a blank Record this will happen.

 

[vbaInet]

I hope your grandchild is doing alright

See here the reasons why:

http://allenbrowne.com/casu-20.html

 

[Margarita]

I know if you have your Form set to "Allow Additions = No" and you open the Form on a blank Record this will happen.

I have Allow Additions set to Yes, but Data Entry set to No. Does that make a difference?
Thanks!

 

[Margarita]

I hope your grandchild is doing alright

See here the reasons why:

[URL="http://allenbrowne.com/casu-20.html"]http://allenbrowne.com/casu-20.html[/URL]

My grandchild is still throwing a tantrum and won't take off the invisibility cloak

Thanks for the resource link. I went through it and checked that none of those problematic conditions apply to me. I don't have any filters set and my recordsets are legit- I have plenty of records to show.

I was stumped by this, so I re-created the form and the new one opens without a problem. I'm glad I have it resolved, though it would have been nice to figure out what went wrong with the original form.

Thanks for taking a look at this!

 

[vbaInet]

Alright, upload your db let's have a look. I don't need to see confidential data.

 

[Margarita]

Alright, upload your db let's have a look. I don't need to see confidential data.

Hello, uploaded is a copy of my db with dummy data and only the relevant forms and tables.
Thank you!

 

[vbaInet]

Ok, the grey area of your main form is too tall and the vertical scroll bar is not visible. Look below the Footer section of the main form and reduce that grey area.

 

[Margarita]

Ok, the grey area of your main form is too tall and the vertical scroll bar is not visible. Look below the Footer section of the main form and reduce that grey area.

Wow! What an embarassingly silly mistake on my part. I am beet red!
Thank you so much for catching that!!

 

[vbaInet]

No problemo!