All Fields disappear in Forms view

[woodproj]

When I create a Form using the Forms wizard, if I select data from more than
1 table the form looks good in Design view, but is totally blank in Form
View. Ideas??

 

[Rick Brandt]

When I create a Form using the Forms wizard, if I select data from
more than 1 table the form looks good in Design view, but is totally
blank in Form View. Ideas??

The detail section of a form is completely blank in normal view when both of
the following are true.

No records are available to display

The form and/or the RecordSource do not allow new records to be added.

Most likely when you added a second table to the query it became read only.
Check the help topic entitled "When can I edit data in a query?"

 

[John Vinson]

When I create a Form using the Forms wizard, if I select data from more than
1 table the form looks good in Design view, but is totally blank in Form
View. Ideas??

The wizard isn't all that bright. If you have more than one table you
would usually do best to use a Form (for the "one" side table of the
relationship) with a Subform (for the "many").

The blank form arises when two conditions are met:

- the Query does not contain any records, for instance because there
are no matching records between the two tables; so you cannot see any
existing records since there are none
- the Query is not updateable, perhaps because you don't have a
Primary Key or a relationship defined; so you cannot see the new
record either

Try creating a Query joining the two tables. Can you see any data? Is
it updateable?


John W. Vinson[MVP]