Modifying the contents of a field on a different form to the one you're on...

[ihatepcs]

Help! I'm trying to set up a transaction screen, which is recording a new record each time a command button is pressed. At the same time as recording the transaction, the account needs to be debited, the account details are on a seperate table, tih it's own form.... anyone got any ideas? I've tried mucking about with the expression builder but it dont wanna know.... Any help would be greatly appreciated! Cheers, Ryan.

 

[Breisi]

Have you tried using VB code within an event to update your account?