467,921 Members | 1,385 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

updating a table from a form

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.
Nov 12 '05 #1
  • viewed: 1859
Share:
1 Reply
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Jason | last post: by
2 posts views Thread by =?Utf-8?B?VmFuZXNzYQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.