Combo List Box Functionality

  • Thread starter Thread starter dgrosh
  • Start date Start date
D

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?
 
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.
 
dgrosh said:
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?
Click to expand...

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"
 
Back
Top