Form using multiple tables

  • Thread starter Thread starter Cabfl
  • Start date Start date
C

Cabfl

I have a form with three tables. In design view everything looks okay, but
the form is blank once you leave design view. Nothing but the title. How do
I see the form outside of design view in order to enter data?
 
Presumably your form is based on a query that joins the three tables.

Does the query return any data? If it does, is the resultant recordset
updatable? (It's very common for queries joining three or more tables not to
be updatable)
 
You didn't happen to set the form's DataEntry property to True, did you? If
so, set it back to False. The Data Entry property doesn't determine whether
records can be added; it only determines whether existing records are
displayed. If the underlying query isn't updatable and you've got DataEntry
set to True, then nothing will appear, since there's no "new record" row to
display.
 
Thanks: I changed the Data Entry property to "No" and I can see the form.
How do I make it updatable?
 
Back
Top