Hello everyone, I am having trouble with a tab control. I am trying to reference a text field on a subform of a tab control using a query.
Main Form: frmSwitchBoard
Tab Control: TabCtl0
Sheet Name: SearchClaims
SubForm: frmClaimSearch
Text Field: Text54
I am trying to reference that field in a query, but I am trying a hard time getting it to find the field.
This is what I have so far:
[Forms]![frmSwitchBoard]![TabCtl0]![frmClaimSearch].[text54]
I tried going through other post and looked at the following link, http://access.mvps.org/access/forms/frm0031.htm, but wasn't able to figure it out.
Any help would be greatly appreciated.
Thanks
Main Form: frmSwitchBoard
Tab Control: TabCtl0
Sheet Name: SearchClaims
SubForm: frmClaimSearch
Text Field: Text54
I am trying to reference that field in a query, but I am trying a hard time getting it to find the field.
This is what I have so far:
[Forms]![frmSwitchBoard]![TabCtl0]![frmClaimSearch].[text54]
I tried going through other post and looked at the following link, http://access.mvps.org/access/forms/frm0031.htm, but wasn't able to figure it out.
Any help would be greatly appreciated.
Thanks