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

Save data in new field

P: 28
Can I save the data in a text box with a set control source back to a set field in a different table if the table are not related. I tried to use VB with the Change and After Update with no luck.
Feb 20 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,315
In the After Update event you can use a DoCmd.RunSQL Insert or Update depending on what you need.
Feb 20 '07 #2

ADezii
Expert 5K+
P: 8,599
Can I save the data in a text box with a set control source back to a set field in a different table if the table are not related. I tried to use VB with the Change and After Update with no luck.
How are you going to know which Record in the other Table to save the data to if they are unrelated? Please supply more information.
Feb 20 '07 #3

P: 28
With assistance the problem was solved reference the Date and AutoNumber combining into one text box. Now I need to try and save the info in the text box back to a different field automatically I have tried the After up Date and Change in the
Feb 20 '07 #4

Post your reply

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