By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,929 Members | 634 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,929 IT Pros & Developers. It's quick & easy.

updating a table from a form

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.