subform getting data from other subform

From: "David" <david@xxxxxxxxxxxxx>
Date: 31 Aug 2006 08:47:20 -0700

Using Access 2002. I have a form with several subforms. Subform2
allows the user to insert a record into a table. One of the fields in
this table is an account number, which is displayed in Subform1. I
don't want the user to have to enter the account number in Subform2,
rather, it should pull from Subform1.

How can I accomplish this?

Thanks,

David

.

Prev by Date: Re: Access 2000 needs to be repaired EVERY day
Next by Date: Re: O.T. ==> PING discussion
Previous by thread: O.T. ==> PING discussion
Next by thread: detect locks
Index(es):
- Date
- Thread

Relevant Pages

RE: Keeping SubSubform on New entry
... Subform1 loads the whole list of accounts, while the Subform2 loads the ... recordset related to the 1st account in the list (it does not have filter yet ... Then I've managed to control the Subform2 from the Subform1 by passing ... There is no AccountID in the Parentform underlying table. ...
(microsoft.public.access.formscoding)
RE: Keeping SubSubform on New entry
... Subform1 loads the whole list of accounts, while the Subform2 loads the ... recordset related to the 1st account in the list (it does not have filter yet ... Then I've managed to control the Subform2 from the Subform1 by passing ... There is no AccountID in the Parentform underlying table. ...
(microsoft.public.access.formscoding)