Binding a Combo Box

[pcstechnical.sfhs]

Is it possible to bind 2 different columns of a combo box to a table?
If so, can I bind those 2 columns to 2 different tables?

Secondary Question: Is it possible to bind an entire record of a combo
box to a table/query?

If any of these are possible, how do you do that (the simpler the
answer, the better.)

Thank you

 

[Douglas J. Steele]

A combo box can only have a single bound column.

 

[pcstechnical.sfhs]

A combo box can only have a single bound column.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)









- Show quoted text -

Thank for the clarification-
Do you know of any creative ways around that problem?

 

[Douglas J. Steele]

Thank for the clarification-
Do you know of any creative ways around that problem?

You haven't explained what you're trying to do, so it's difficult to offer
suggestions.

 

[Ken Snell \(MVP\)]

Perhaps this:
http://www.mvps.org/access/forms/frm0058.htm
--

Ken Snell
<MS ACCESS MVP>

 

[pcstechnical.sfhs]

You haven't explained what you're trying to do, so it's difficult to offer
suggestions.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)- Hide quoted text -

- Show quoted text -

I have an initial log in screen that reads from a table (Table1). A
person selects their name from a combo box and types in a password.
Right now, it binds the employee id number of that person to another
table (Table2). However, in Table1 I have the Name, ID, and Location
of where that person works. I would like to record the location of
that person into another, seperate table (Table 3).

Having it in a seperate table allows me to use it for filtering
purposes in another form.