Form using multiple tables

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

 

[Douglas J. Steele]

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)

 

[Cabfl]

I entered test data and received data from the query but it is not updatable.

 

[Douglas J. Steele]

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.

 

[Cabfl]

Thanks: I changed the Data Entry property to "No" and I can see the form.
How do I make it updatable?

 

[Douglas J. Steele]

If the underlying query isn't updatable, you can't.

Check what Allen Browne has at http://www.allenbrowne.com/ser-61.html for
some things you can check to see why the query isn't updatable.