updating a table from a form

[Derek Davlut]

I have a Table that contains data that I use in a query to manipulte the
data through expressions. I have a form that uses the query for manipulating
the data. How do I write the changed values back to the table from the form?
I know it changes the query values so do I have to use an update query? I
also need this to be refreshed in realtime. I have tried relationships but I
find it adds a drop-down box to the table and is not really what I need for
this particular situation.

thanks,
Derek.

[WindAndWaves]

I would try to make the table the recordsource for the form in that way you
prevent the problem altogether.

The other option is to make a query the source of the form, but make the
source of the query to be the table.

In that way it is always real-time and you do not open yourself up for a
raft of problems when updating the data.
"Derek Davlut" <de****@trico.on.ca> wrote in message
news:c7**********@news.storm.ca...

I have a Table that contains data that I use in a query to manipulte the
data through expressions. I have a form that uses the query for manipulating the data. How do I write the changed values back to the table from the form? I know it changes the query values so do I have to use an update query? I
also need this to be refreshed in realtime. I have tried relationships but I find it adds a drop-down box to the table and is not really what I need for this particular situation.

thanks,
Derek.

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.679 / Virus Database: 441 - Release Date: 07/05/2004