View Full Version : Solved: update two tables fields from one text box
boneKrusher
02-09-2006, 06:16 AM
Hi All,
How do update two different tables (fields) from one text box from a form?
Thanks
matthewspatrick
02-09-2006, 07:40 AM
Can you provide some more detail on what you are trying to do?
Patrick
boneKrusher
02-09-2006, 11:00 AM
I figured it out. I ran an update query....
UPDATE Audit_Schedule, [Approved Venders] SET Audit_Schedule.aactive = Forms!Venter_Entry!Active
WHERE (((Audit_Schedule.Vender_ID)=[Forms]![Venter_Entry]![CONTROL NUMBER]));
thanks anyway!
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.