Getting a blank form in form view

[Nimo]

Hey guys,




I have three tables and one form. Each table is unrelated, but for the user's convenience I created a form where the end user can fill in the form and the data gets saved in its relevant table. So I made a query where all the fields I need in the form are in that query. Then I made this query the data source for my form. It worked out well in design view, but when I switch to form view I get a blank form, no fields not even the background of the form...

Any suggestions of how to fix this blank form issue?

[pbaldy]

Can you add data via the query? My guess is not, as it's probably read only:

http://allenbrowne.com/ser-61.html

[June7]

A form can enter/edit data for only one table. If the form RecordSource includes multiple tables with multiple 1-to-many relationships, the dataset might not be editable, as noted by Paul.

It is possible to include lookup up tables in the form RecordSource to display related info but do not allow edit of those fields. Use of INNER JOIN requires existing related records in all tables for any record to retrieve in query. This could be cause of blank form.

[pbaldy]

And once again I'll get out of the way.