Save data in new field

[DeanO]

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.

[Rabbit]

In the After Update event you can use a DoCmd.RunSQL Insert or Update depending on what you need.

[ADezii]

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.

[DeanO]

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