F
Fred Boer
Hello:
I have an unbound textbox on a form ("Frm_AuthorSearch", "txtCutter"). In
the current event of the main form I have the following code:
Me.txtCutter = Forms!Frm_AuthorSearch!Frm_CutterSubform.Form!Cutter
The subform ("Frm_CutterSubform") uses a query as its recordsource. The
subform has a bound control called "Text0", which is bound to a calculated
expression in the query. The expression in the query is called "Cutter".
I'm confused as to *why* this should work, (since it does *appear* to
work).... I mean, I would expect the following to work...
Me.txtCutter = Forms!Frm_AuthorSearch!Frm_CutterSubform.Form!Text0
.....since Text0 is a control on the subform. But in the original code,
"Cutter" refers to a field in the underlying query, not a control. Can you
refer to the actual fields which form the recordsource for a form as well as
the controls on a form using the same syntax?
Thanks!
Fred Boer
I have an unbound textbox on a form ("Frm_AuthorSearch", "txtCutter"). In
the current event of the main form I have the following code:
Me.txtCutter = Forms!Frm_AuthorSearch!Frm_CutterSubform.Form!Cutter
The subform ("Frm_CutterSubform") uses a query as its recordsource. The
subform has a bound control called "Text0", which is bound to a calculated
expression in the query. The expression in the query is called "Cutter".
I'm confused as to *why* this should work, (since it does *appear* to
work).... I mean, I would expect the following to work...
Me.txtCutter = Forms!Frm_AuthorSearch!Frm_CutterSubform.Form!Text0
.....since Text0 is a control on the subform. But in the original code,
"Cutter" refers to a field in the underlying query, not a control. Can you
refer to the actual fields which form the recordsource for a form as well as
the controls on a form using the same syntax?
Thanks!
Fred Boer