form blank in form view

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I have a form which has a source query that links several
tables. It shows all the controls in design view, but
the form view is blank. Does anyone have any ideas that
might help me find the cause of this problem? It seems
to be specific to forms based on this query. Other
queries / forms seem to be OK.
Can I just say that I think this site is fantastic, and I
am particularly grateful to those of you who give of
their time and knowledge to help struggling newbies such
as myself.
 
The detail section of the form goes completely blank if:
a) there are no records to display, and also
b) no new records can be added.

You probably know why a) is the case, e.g. no records in table, opened
filtered, or opened in Data Add mode.

b) could be because your query is read-only. To test if that is the case,
try opening the query directly from the Database window, and see if you can
add a new row there. If not, you will have to redesign the query (e.g. drop
some tables, change join types, skip the aggregation, ...) so that records
can be added.

If the query is not read-only, then check that the form's AllowAdditions
property is set to Yes.
 
Back
Top