why does Assess 03 form blank out after adding > 1 new field list

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

Guest

I created a form with multiple tables. I decided to add more fields from new
tables to the form. When I go to the Record Source of the form to add more
than 1 new field to the query, my form blanks out. Why does this happen?
 
Vivacious said:
I created a form with multiple tables. I decided to add more fields from new
tables to the form. When I go to the Record Source of the form to add more
than 1 new field to the query, my form blanks out. Why does this happen?
Click to expand...

Your query modifications have produced a query with zero rows of output (likely
due to the joins between tables) and which has a non-editable recordset. When a
form has no records to show and no ability to add new ones it appears completely
blank.

It is unusual to create a query with more than one or two tables that will still
allow edits. Combining lots of tables in a query is great for analysis and
reporting, but is seldom a good idea for use with forms.
 
Back
Top