Enter Data in Form Created From a Query

D

DS1MAN

Is it possible to enter data in a form that was created from a query. For
example, I created a query from several tables. I then created a form from
the fields of the query but when I try to enter data no data can be entered.
 
R

Rick Brandt

DS1MAN said:
Is it possible to enter data in a form that was created from a
query. For example, I created a query from several tables. I then
created a form from the fields of the query but when I try to enter
data no data can be entered.
Click to expand...

See the help topic "When can I update data in a query?" Many things can
render a query non-editable and having more than one table "can" cause it,
but it's not a hard limitation. Certainly the more tables you add the less
likely it is that the query will allow edits.

Access/Jet is actually very forgiving in this area compared to other
databases. Many databases absolutely forbid updates in a multi-table query
no matter how simple.
 
Top