No problems..
OK, combo box 101... you might know this but I don't know what you know.... you know??
Lets say you have a combo box. The ROW SOURCE property is a SQL string:
Code:
SELECT EmpID, FullName FROM tblEmployees"
So two fields are available..
In design view, selecting the combo box:
On the DATA tab:
The BOUND COLUMN =1 (EmpID - an Autonumber type)
On the FORMAT tab:
The COLUMN COUNT = 2
The COLUMN WIDTHS = 0
If you leave the COLUMN WIDTHS empty/nothing/NULL, the first column will be displayed after a selection is made.
If you DON"T want to see the EmpID, set the COLUMN WIDTHS to 0 (zero). This hides the first column and displays the 2nd column (the width is not specified).
If you change the COLUMN WIDTHS property to 0, 1.75, the first column (EmpID) will be hidden (width set to zero) and the second column width will be set to 1.75".
If I include both the assessment and employee in one 'find a record on my form based on the value I selected on my combo box' it just gives my numbers instead of text
Not sure what you mean by this. Do you have 2 combo boxes?
it just gives my numbers instead of text
Are we talking combo boxes or after a search (on a form)?