Subform reference returns value from query expression

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top