Form display blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a form from a query. When I run the form I only see blank form with no fields, but in design view all filled are there and have been correctly linked to each field.

The same occurs when I use a subform

Any idea what I am doing worng

Thanks for hel

Sid
 
I created a form from a query. When I run the form I only see blank form with no fields, but in design view all filled are there and have been correctly linked to each field.

The same occurs when I use a subform.

Any idea what I am doing worng.
Click to expand...

This will occur if two conditions are both true:

- The Form's Recordsource query has no records, so that there is no
existing data to display; and
- the Recordsource is not updateable, so you can't see the new record
either.

Try opening the Query in datasheet view. Does it return any records?
Is there a *> new record line at the bottom? I'm guessing no to both.

If you could describe the query, and perhaps post the SQL, someone may
be able to steer you in the right direction.
 
Back
Top