How can I update data of queries from forms in Access?

A

Aurelio

Hi,

I have created a form depending on a query.
The form lets me read the data contained in the query, but not update data.
I don´t know how to do it, but it is possible.
How can I do it? Must I change any property? From where? The properties of
the query, of the form?
Please, I would be very pleasure if you can help me. I have been spending a
lot of time trying to resolve this doubt.

thank a lot
 
R

Rick Brandt

Aurelio said:
Hi,

I have created a form depending on a query.
The form lets me read the data contained in the query, but not update
data. I don´t know how to do it, but it is possible.
How can I do it? Must I change any property? From where? The
properties of the query, of the form?
Please, I would be very pleasure if you can help me. I have been
spending a lot of time trying to resolve this doubt.

thank a lot
Click to expand...

There is an entire help topic named "When can I update data in a query".
More often than not you cannot do so.
 
R

Rick Brandt

Aurelio said:
Thanks a lot, Rick

Where Can I find that help topic, please?
Click to expand...

In Access 97 help the index search is...

queries
modifying results
When can I update data in a query?

I can't say if that will work in the newer versions, but I'm pretty sure the
topic exists in all of them.
 
J

John W. Vinson

I have created a form depending on a query.
The form lets me read the data contained in the query, but not update data.
I don´t know how to do it, but it is possible.
Click to expand...

If you are trying to create a multi-table query and base a Form on it, you may
have difficulty. Often it is better to use a Form (for the "one" side of a
relationship) and one or more Subforms (for the "many" side tables).

If you wish, you may open your Query in SQL view and post the SQL text here.
Someone may be able to see why it is not updateable and suggest a solution.

John W. Vinson [MVP]
 
A

Aurelio

Thanks to both,

I will try it tomorrow morning because now it is too late in Spain!!!

Thanks a lot

Regards
 
Top