Solved: update two tables fields from one text box

[boneKrusher]

Hi All,

How do update two different tables (fields) from one text box from a form?

Thanks

[matthewspatrick]

Can you provide some more detail on what you are trying to do?

Patrick

[boneKrusher]

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!