Transfer Data to Different Form

  • Thread starter Thread starter Elyse
  • Start date Start date
E

Elyse

Hi,

I've created two forms as follows:
[Ltr_Acct] and
[Acct] this form has a button that opens form [Ltr_Acct],

Both forms contain a field named [Account_Number].

the table used for form [Ltr_Acct] has no records, howerver the table used
for form [Acct] does have records.

How do I program the button on form [Acct] so that when form [Ltr_Acct]
opens the account number from [Acct] is automatically entered into the
[Account] field on form [Ltr_Acct]?

The LinkCriteria does not work becuase there are not records in the
[Ltr_Acct] table/form.

Thax
elyse

Thxs.
 
In the OnClick event of the button, enter:

DoCmd.OpenForm "Ltr_Acct"
Forms!Ltr_Acct!Account = Me!Acct

Cheers,
Pavel
 
Back
Top