Leo_Polla_Psemata
Registered User.
- Local time
- Today, 14:26
- Joined
- Mar 24, 2014
- Messages
- 364
Hi
I have three tables, linked one to many, table A, B and C;
Then, I have Four (4) forms. three of those (Af, Bf. Cf) are form subform subform
Af (single), Bf (single- child of Af) , Cf (continue form, child of Bf) and the continues form ABC
which combines few basic details from A B C and works as summary. I find fast the one out of 4000 records.
Then i click a button and go fast to specific form.
I use the following code and open specific record in form Af
DoCmd.OpenForm "Af", acNormal, "", "[field1_from_A]=" & "'" & .field1_from_A & "'", , acNormal
The question is, while AF opens at specific record, how could i open the subform Bf to a specific record as well ?
I have three tables, linked one to many, table A, B and C;
Then, I have Four (4) forms. three of those (Af, Bf. Cf) are form subform subform
Af (single), Bf (single- child of Af) , Cf (continue form, child of Bf) and the continues form ABC
which combines few basic details from A B C and works as summary. I find fast the one out of 4000 records.
Then i click a button and go fast to specific form.
I use the following code and open specific record in form Af
DoCmd.OpenForm "Af", acNormal, "", "[field1_from_A]=" & "'" & .field1_from_A & "'", , acNormal
The question is, while AF opens at specific record, how could i open the subform Bf to a specific record as well ?