Reference a value in a subform???

  • Thread starter TA Bran via AccessMonster.com
  • Start date
T

TA Bran via AccessMonster.com

Hello all,

I have a macro that uses FindRecord to search for a record based on a value
in an open subform. The macro is currently returning an error that it
cannot find the form--It's as if I misspelled the form name in the FindWhat
field though I assure you I did not. As a matter of fact, if I open the
subform independant of the form it's embedded in, the macro runs perfectly.
I'm wondering if there is some special way I need to reference the form
name when it is embedded in another form...??? Anyone have any ideas or
suggestions?

I should also mention that the subform is also within a Tabbed control in
case that makes a difference...

Many thanks,

TA
 
T

TA Bran via AccessMonster.com

I figured it out. The context I used was:

=[Forms]![ParentFormName]![SubFormControlName]![Control]


Best,

TA
 

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