well, presumably you have a table to hold staff member records, which
includes each staff member's staff number and classification. base your
combo box's RowSource (*not* ControlSource) on that table. as an example:
SELECT StaffID, StaffLastName & ", " & StaffFirstName As MemberName,
StaffNumber, StaffClassification FROM tblStaff Order By StaffLastName,
StaffFirstName;
set the Number of Columns property to 4. set the ColumnWidth property to 0",
2", 0", 0"
so the primary key field (StaffID) is hidden, the name column is 2 inches
wide, and both the StaffNumber and StaffClassification columns are hidden.
name the combo box control cboStaff
add two unbound textbox controls to the form. set the first textbox's
ControlSource to
=[cboStaff].[Column](2)
that will display the StaffNumber value for the name chosen in the combo
box.
set the second textbox's ControlSource to
=[cboStaff].[Column](3)
that will display the Classification value for the name chosen in the combo
box.
hth
Puddlypooh said:
I know this sounds like a pretty simple help request, but I haven't worked
with Access for a while so I am very rusty.
I need to use a combo Box to find staff name and once a staff member has
been selected then it will automatically display the staff number and their
classification.
If anyone can help me it would be greatly appreciated.
