reference

xxyy

Registered User.
Local time
Today, 10:54
Joined
Feb 24, 2006
Messages
51
Please help, how can I refer to the field of a subform in Visual Basic when the (main) form is open?

A)
Private Sub supplierID_AfterUpdate()
Forms![invoices]![KombináltLista4].Requery
End Sub

B)
Private Sub supplierID_AfterUpdate()
Forms![details1 Segédűrlap]![KombináltLista4].Requery
End Sub

These don't work. (The main form: INVOICES; the subform:DETAILS1 Segédűrlap; KombináltLista4 is the name of a combo box)

The version B work, when I open the form and the subform together, but of course I'd like to work only on the form (where the subform is displayed as well, but I can't refer to it...)

THX
 
Forms!MainFormName!SubFormName!FieldNameSub
 
Forms!MainFormName!SubFormName.Form!FieldNameSub
 

Users who are viewing this thread

Back
Top Bottom