queries

  • Thread starter Thread starter alicia
  • Start date Start date
A

alicia

how do you make a query updatable?
i have a form based on my query and i want to be able to
update it. any ideas?
cheers
 
-----Original Message-----
how do you make a query updatable?
i have a form based on my query and i want to be able to
update it. any ideas?
cheers
.
Click to expand...
set the form's RecordSource property to the query. set
each form control's ControlSource property to a field in
the query.

suggest you check first to make sure your query is
updateable (multi-table queries sometimes are not). open
the query in datasheet view and add a record. if Access
allows you to do that, you should be able to add records
from the form just fine.
 
how do you make a query updatable?
Click to expand...

There are many ways in which a query can be made non-updateable; for
instance a Totals query (or any query including a Totals query) will
not allow updating. The most common reason is that if you have two (or
more) tables joined in the Query, you must have a unique index on the
joining field in the "one" side table.

If you wish, open the query in SQL view and post the SQL text here.
Someone may spot the problem.
 
You should be able to update the information in your query
as long as you havn't grouped the information.
 
Back
Top