How do I refer to a control on a tabbed control?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a database of user equipment for the west coast. I have a
table called WCEquip_Tbl. The table has 9 fields that are ID, Key, Phones,
Faxes, ... ect.

The Key field is used to filter the data.

I have created a form called NewEquip where new equipment is entered into
the table. The Record Source of the form is the WCEquip_Tbl table.

On the NewEquip form is a tab control with pages for each new piece of
equipment. There is a text box on each page with the Control Source as Key.
As I click from page to page I would like to assign a different value to the
text box, ie. on the Fax page I want the text box assigned the value of Fax,
on the Phone pages the text box is assigned the value of Phone. So as the
data is entered into the table the Key field gets Fax or Phone or Printer or
System... depending on what type of equipment is being entered. One piece of
equipment per page.

How do I refer to the text box on the tab control?
Is this a nested reference?

Should it be something like:
Forms![NewEquip]![Tabctl0].Form![Page].Form![Textbox] = "Value I Want"

Thanks for your help... Dan
 
It doesn't matter that it's on a tab control. You cannot use the same name
twice on a form, so you simply refer to it by its name.
 
Back
Top