Can a form update 2 different tables at once?

[marathonlady]

Is there a way I can have the record source for a form one table, but have another table updated too?

Thanks.

 

[Dugantrain]

How's your VBA? How's your SQL?

 

[dcx693]

Yes. But you might want to join the two tables together in a query so you just update one query (which will then update the separate tables) without having to do some programming.