Disappearing fields in Form View

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy Hathaway - 23 Mar 2007 04:19 GMT

I have a simple form created in Access 2007 with a few dozen fields to add
information into a database, adding the fields through Design View.

Nearly at the end of creating this form, I checked it in Form View to see
how it looked, but all the fields in the Detail section of the form are not
there anymore, as if Access hasn't loaded it all up. The Form Header is
available, yet the buttons in the header are frozen. This leads me to
believe that the form froze halfway through loading up in Form View. Is
there something that I'm doing wrong that's making the form freeze?

Reply to this Message

Allen Browne - 23 Mar 2007 05:56 GMT

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a simple form created in Access 2007 with a few dozen fields to add
> information into a database, adding the fields through Design View.
[quoted text clipped - 6 lines]
> believe that the form froze halfway through loading up in Form View. Is
> there something that I'm doing wrong that's making the form freeze?

Reply to this Message

Jimmy Hathaway - 23 Mar 2007 15:31 GMT

That really doesn't help out that much though. I did add the pop-up window
code that will pop-up if there isn't any records in the table that the form
accesses, (which it does pop-up when I open up the form), but there are
records in the table. I'm "ALMOST" sure there isn't any queries for this
form setup yet to mess that up, especially since the form is only accessing
one table and is for data entry purposes.

The problem that page describes is the problem I'm experiencing, but I
cannot see how I'm experiencing both scenario A and scenario B at the same
time? It doesn't seem plausible.

Reply to this Message

Allen Browne - 24 Mar 2007 02:10 GMT

Open the form in design view.
Open the Properties box.
Make sure you are looking at the properties of the form (not of a text box.)

The first item on the Data tab is Record Source.
Make sure this is set to your table (not a query.)

Make sure you have these settings:
Recordset Type Dynaset
Allow Additions Yes

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> That really doesn't help out that much though. I did add the pop-up
> window
[quoted text clipped - 9 lines]
> cannot see how I'm experiencing both scenario A and scenario B at the same
> time? It doesn't seem plausible.

Reply to this Message