Writing to fields in a query

H

How1

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.
 
S

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?
Click to expand...
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 <--
 
B

Bob Howard

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