I'm trying to reference a field in a subform to assist a query I'm writing on the form to populate a list box.
The help info is not very helpful in assisting me.
taken from the Access 97 help files:
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.
· Type the identifier for the form that contains the subform, followed by the name of its subform control, the . (dot) operator, and the Form property. For example, the following identifier refers to the Orders Subform subform on the Orders form:
Forms![Orders]![Orders Subform].Form
---
I would assume that to reference a field within that subform, you simply add on the field name. This does not work.
Any ideas?
Thanks,
Mike
The help info is not very helpful in assisting me.
taken from the Access 97 help files:
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.
· Type the identifier for the form that contains the subform, followed by the name of its subform control, the . (dot) operator, and the Form property. For example, the following identifier refers to the Orders Subform subform on the Orders form:
Forms![Orders]![Orders Subform].Form
---
I would assume that to reference a field within that subform, you simply add on the field name. This does not work.
Any ideas?
Thanks,
Mike