No Form In Form View

  • Thread starter Thread starter Frustrated
  • Start date Start date
F

Frustrated

I have a form that when viewed in Design View, everything
is okay. If I try to view the form in Form View, all I
get is the background color. This is the form with the
least amount of controls in the database, so I know it
can't be because there are too many of them in the form.

I've tried the Compact & Repair with no results. I've
even rebooted my PC many times, still with no results.

Has anybody else experienced this and if so, how did you
resolve it? Thanks.
 
I have a form that when viewed in Design View, everything
is okay. If I try to view the form in Form View, all I
get is the background color. This is the form with the
least amount of controls in the database, so I know it
can't be because there are too many of them in the form.
Click to expand...

This usually is the fault of the Query upon which the form is based.
If the Query returns no records, you won't see any existing records;
and if it's not updateable (or if the AllowUpdates or AllowAdditions
properties of the form are true) you won't see the new record either -
you'll just see a blank slate.

Try opening the Form's Query in datasheet mode. Do you see any data?
do you see the *> new record line? If not, check the query to see if
it has something that would keep it from updating (see "Updateable" in
the online help), or open the query in SQL view and post it here.
 
I have had this happen and the form was corrupted.
Try creating a new form by copying and pasting all the controls and the code
module into a new blank form.

Ragnar
 
Back
Top