Pulling subform values (Access 2000 SR-1)

Topic

New Reply

How do you pull values from a subform? I know that forms use the Forms![Form Name]!.Field.Value syntax, but I’m not sure how to get a value from a subform. I’ve looked high and low in the Access Help and on the Web, but have had no luck.

Thanks,
Bob

Reply | Quote

Replies

In Access 97, Help has a topic: Referring to subforms in expressions , that say this:

To refer to a subform or subreport
Refer to the subform or subreport control on the form or report that contains the subform or subreport, 
then use the Form or Report property of the control to refer to the actual subform or subreport.

Reply | Quote

Thanks, that worked.

In VBA, I used:

PrimaryCR = [Forms]![Corrections Entry]![CR Subform].[Form]![CorrCR]

Where Corrections Entry is the main form, CR subform is the subform, and CorrCR is the field value I want from the CR subform.

Reply | Quote

Thanks, that worked.

In VBA, I used:

PrimaryCR = [Forms]![Corrections Entry]![CR Subform].[Form]![CorrCR]

Where Corrections Entry is the main form, CR subform is the subform, and CorrCR is the field value I want from the CR subform.

Reply | Quote

In Access 97, Help has a topic: Referring to subforms in expressions , that say this:

To refer to a subform or subreport
Refer to the subform or subreport control on the form or report that contains the subform or subreport, 
then use the Form or Report property of the control to refer to the actual subform or subreport.

Reply | Quote

Here is a document on all the ways to refer to a subform. I would like to give credit, but I do not remember where I got this on the net.

Reply | Quote

It was Keri Hardwick on The Access Web… Here’s the link…
http://www.mvps.org/access/forms/frm0031.htm%5B/url%5D

Reply | Quote

It was Keri Hardwick on The Access Web… Here’s the link…
http://www.mvps.org/access/forms/frm0031.htm%5B/url%5D

Reply | Quote

Here is a document on all the ways to refer to a subform. I would like to give credit, but I do not remember where I got this on the net.

Reply | Quote