Referencing Text Box Control in Tab Control Access 2007

All,

I am having an issue with referencing text box controls within a form tab control.

I have enclosed my current syntax that is bugging.

Can anyone help me define the correct method of doing this please?

CF

NEWCustomerDataCollectionArray(1) = Forms!frm_MAIN!TabCtl0!Pages("Customer").Controls("Company").Value

Open in new window

creativefusionAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
You should only need this:

NEWCustomerDataCollectionArray(1) = Forms!frm_MAIN!Company
0
 
creativefusionAuthor Commented:
Excellent help.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Forgot to mention.  No special syntax is required to reference Controls on a Tab Control ... although this is probably not ... obvious.

mx
0
All Courses

From novice to tech pro — start learning today.