subform

[John]

Have a combobox (ChargeAccountID) on a subform (zPurchaseOrderItems)
that I need to reference. I have the following but it doesn't seem to
be correct and I am not finding the issue.

Form!zPurchaseOrderItems.Form!ChargeAccountID.column(0)

Can someone take a look and see what is wrong?
Thanks... John

 

[John W. Vinson]

Have a combobox (ChargeAccountID) on a subform (zPurchaseOrderItems)
that I need to reference. I have the following but it doesn't seem to
be correct and I am not finding the issue.

Form!zPurchaseOrderItems.Form!ChargeAccountID.column(0)

Can someone take a look and see what is wrong?
Thanks... John

The correct syntax is

Forms!mainformname!subformcontrolname.Form!ChargeAccountID

You must start with the name of the main form on which the subform appears,
and then use the name of the Subform Control (which may or may not be the same
as the name of the form which is within that control).
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[John]

The correct syntax is

Forms!mainformname!subformcontrolname.Form!ChargeAccountID

You must start with the name of the main form on which the subform appears,
and then use the name of the Subform Control (which may or may not be thesame
as the name of the form which is within that control).
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

I was missing the main form name. DUH on my part.
Thanks.