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

Updating Records

P: 10

I have a subform where the user make changes to several filtered records in view.
when clicking the updating button, I run the update query to perform some calculations and update the table for only those filtered records.

however with an update query, its only updating to the first record in view.

any workaround for this problem?

much appreciated
Apr 29 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
I get the impression you're updating "calculated fields".
That's a bad practise and you should remove those fields from your table.
The general approach in a case like this is to use the calculations in a query when you need the result. That way the values will always be "inline" with the data.

To update a filtered set for a certain value (entered "outside" the filtered (sub) form) you can create a query dynamically in code, but take my advise not to store calculated data.

Apr 29 '07 #2

P: 10
Thank you very much for the advise
Apr 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.