Form

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I created a form based on query using the form wizard; however, the form is
blank in form view, but you see the fields in design view. anyone know wht
the problem can be?
 
Chris said:
I created a form based on query using the form wizard; however, the form is
blank in form view, but you see the fields in design view. anyone know wht
the problem can be?
Click to expand...


The query is returning no records, and either the form doesn't allow
additions or the query itself is not updatable. If the latter, see the help
topic "When can I update data from a query?".
 
can you explain what you mean that the query itself is not updatable. when i
look at the query in the query obj. it is blank also. i know that the form
has several subforms based on tbles which i enter one line data on all the
tbles.
 
Chris said:
can you explain what you mean that the query itself is not updatable.
when i
look at the query in the query obj. it is blank also. i know that the form
has several subforms based on tbles which i enter one line data on all the
tbles.
Click to expand...


Some queries are not updatable. For example, a totals query (one using
grouping and summing) is never updatable. In general, a non-totals query
involving one table is almost always updatable, and a query involving two
tables is usually updatable. A query involving three or more tables may or
may not be updatable, depending on the relationships of the tables.

If your query is coming up blank, without even providing an empty row for
you to enter new data, then it is returning no records *and* it is not
updatable. For a more detailed discussion of query updatability, follow
this link to the help topic I mentioned earlier:

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP051880011033

If you can't figure out why your query is not updatable, post the SQL view
of your query and explain what it is you are trying to do.
 
Back
Top