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

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top