Difference between Table and Query

[lizray]

I Have a form containing a Sub-Form and these are linked by a field called "RESID". I use the double-click event on a control in the Subform to open up another form called "Details"in FORM VIEW to display the record. This works well when I use a table as the control source for the subform and "Details" form. But I now need an extra control which I calculate and to do this I run a Query based on the table and then use this for the control source of the Subform and "Details" form. When I try to enter data on a new record on the "Details" form, I get a message "Field cannot be updated". Why should there be a difference between a table and query as the Recordsource??

 

[HarleyQuinn]

When you use a table you are linked to that table and you can update it.

When you use a query you are linked to something which is displaying data from that table and not the table itself which is why you can't update it.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lizray]

Thanks Harleyquin and PHV. Your suggestions have been helpful