Reference a field on a tab control

RevJeff

Registered User.
Local time
Today, 18:42
Joined
Sep 18, 2002
Messages
129
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
 
You do not need to reference the tab control. Just reference your form, subform and the control. Something like:
Code:
Forms!MainFormName!SubformControlName.Form!TextBox
 
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

Hi..

Try this way..:


[Forms]![frmSwitchBoard]![frmClaimSearch].[Form]![Text54]


opps... ;)

I saw now Mr. B..
 

Users who are viewing this thread

Back
Top Bottom