Combo List Box Functionality

[dgrosh]

I have built an input form in Access. I have a Combo List Box where they can
choose their name as the person who is inputting the information. I would
like the Combo List Box to refer to a table (STAFF_MANAGER TABLE) to list the
names of employees. However, the information actually needs to be inputted
into the MASTER TABLE. In my form, I took that field and changed it to a
combo box. Now what do I need to do to have it pull the names from
Staff_Manager Table and still input it in the Master Table?

 

[Ken Snell MVP]

Set the RowSource property to a query that returns the desired information
from which you'll make the selections. The ControlSource property should
have the name of the field in the "Master Table" where the selection is to
be stored.

Also, be sure that you update the BoundColumn, ColumnWidths, and ColumnCount
properties to match what you want.

 

[Arvin Meyer MVP]

I have built an input form in Access. I have a Combo List Box where they
can
choose their name as the person who is inputting the information. I would
like the Combo List Box to refer to a table (STAFF_MANAGER TABLE) to list
the
names of employees. However, the information actually needs to be
inputted
into the MASTER TABLE. In my form, I took that field and changed it to a
combo box. Now what do I need to do to have it pull the names from
Staff_Manager Table and still input it in the Master Table?

Use a row source similar to:

Select MgrID, LastName, FirstName From [STAFF_MANAGER TABLE] Order By
LastName;

Set the Column Count to 3
Set the Bound Column to 1
Set the ControlSource to MgrID
Set the ColumnWidths to: 0", 1", 1"

 

[dgrosh]

Thanks so much Ken and Arvin... exactly what I needed!!!! Have a great day!