How to reference forms/subforms on a tab control 3

[dpav29]

My tab control is on the main form, then there's the tab "page" then a form and a subform. I can't figure out what is necessary to reference the subform for a requery.

Is it Forms!MainForm!tabcontrol!page!form!subform Seems like a lot, and i've tried several variations with no luck. . . hoping it is something easy!

Thanks!

 

[PHV]

When in the main form use the Expression builder to discover how to reference a control on the subform.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dpav29]

Thanks. . . .great tip!

 

[misscrf]

can you tell me if you have to do anything different if you are referencing a combo box? I am trying to create a flow for tabbing from the main form to each subform on a tab control with pages. I have my code, but it says

"An expression you entered is the wrong data type for one of the arguments."
This is what I have:

DoCmd.GoToControl Forms![frmCandidateEntry]![frmPhoneEntry].Form![cmbPhoneTypeID]

I also tried a Forms![frmCandidateEntry]![frmPhoneEntry].Form![cmbPhoneTypeID].setfocus but nothing happens. The tab just goes back to the first field of the subform I am on.

This is being referenced in the onexit code of a zip field, on an address subform on a tab control. The phone subform is on the same page of the tabcontrol.

I have more to do after that, but I am trying to get this code worked out so that I can create a navigational tabbing flow to the form(s).

Thanks if you can help!

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[misscrf]

sorry I put this in reply to the wrong post. I will repost in the right place.

misscrf

It is never too late to become what you could have been ~ George Eliot