Writing to fields in a query

[Guest]

Hi,

I wish to set-up a form that writes to fields in a query. Can anyone suggest
how this is done?

I have so far set-up a command button to open the form. I have set the
properties of the form to allow the user to edit the data. However the form
is not allowing me to write to the fields in the query. What am I doing wrong?

Thanks in advance.

 

[Stefan Hoffmann]

hi,

I have so far set-up a command button to open the form. I have set the
properties of the form to allow the user to edit the data. However the form
is not allowing me to write to the fields in the query. What am I doing wrong?

Open your query directly and try to edit or insert data. Does this work?
If not, open the query and append the primary key fields of the
underlying tables.


mfG
--> stefan <--

 

[Bob Howard]

Your query probably has a many-to-one relationship ... cannot write to such!
Bob