Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

field in sub-form of a sub-form

Status
Not open for further replies.

joeblow3

Programmer
Jun 9, 2008
21
CA
What is the code in the main Form please.
I want to change the Row Source of a field in a sub-form of a sub-form (of the main form)?
Thanks in advance.
 
A field doesn't have "Row Source". Charts, combo boxes, and list boxes have Row Sources. You can generically reference a control on a sub-subform with syntax like:
Me.sfrm1CtrlName.Form!sfrm2CtrlName.Form!ControlOnLastSubform

There might be a difference between your subform control name and its source object.

Duane
Hook'D on Access
MS Access MVP
 
The field I am talking about is a List Box. thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top