Disappearing fields in Form View

G

Guest

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?
 
G

Guest

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.
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top