Why do I get a blank form view when combining tables in a form?

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

Guest

When I combine 2 or more table into a form I can see the form in design view,
but not in normal view. Can someone help me resolve this problem?
 
You can have only one record source for a bound form. It would not be likely
you would have two tables that are a one to one relationship. If you do,
then you would need to create a query to use a the record source for your
form. What you more likely have is a one to many relationship between your
tables. The table on the one side should be the record source for the form.
Then you should have a sub form that has the many side table as its record
source.
 
This typically happens when the form data source has no records AND the user
is not able to add a new record.

Pretty good chance that you created a query that is not updatable and it is
not pulling any records to display.

Try opening the query. Can you see any data? Can you add data? If both
answers are "No", that is your problem.
 
Maxine said:
When I combine 2 or more table into a form I can see the form in design view,
but not in normal view. Can someone help me resolve this problem?
Click to expand...

The detail section of a form appears completely blank when there are no records
to display and no ability to add new ones. Most likely your multi-table query
returns zero rows and does not allow inserts/updates (many multi-table queries
are read only).

Check the help topic "When can I update data in a query?"
 
Back
Top