Access Switchboard question

G

Guest

Hello,

I set up a Switchboard, using Access's Switchboard Manager.
It works fine.

I was looking at the code & there is a field called "SwitchboardID" where I
guess Access assigns a number for each Switchboard in the program. My
question is where is it stored on the Form ? I looked at all the controls &
there isnt any called SwitchboardID, yet the code has ME.SwitchboardID

Any help would be greatly appreciated.

Thank you,
Jeff
 
J

Jeff Conrad

The Swithboard form is bound to a table in your database called
"Switchboard Items." If you open this table in Design View you
will see all the various fields. Looking at the various records in
the table may help you understand what is going on behind the
scenes with the form.

Through code the form will display one "menu" of items at a time.
Through the wizard interface you can add/edit/delete items from
your various menus. Behind the scenes the wizard is actually
changing the data in this table. Each SwitchboardID number
corresponds to a different "menu." So the form will display any
matching SwitchboardID numbers and present that as a "menu"
type interface.
 
G

Guest

The form has a record source of the table or a query of the table. Although
you do not see an object of the field Id on the form the fact is that since
the form has a record source that includes the Id field then the ID field in
in the current record of the form.
 

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