Help displaying combo selection other than ID.

[rosscortb]

Hello,

Hoping you can help as don't think I've done this correctly.

I have Employee Table
(ID)
Name etc

Position Table
(ID)
(Position Name)



Position History Table
(ID)
(Employee ID)
Position ID)
Start Date
End Date

I have created a from with Employee(ID) and sub form with Position History Table
I was wanting to have the position name as a combo box so the user can select the new position name that the employee has, any ideas?



Thanks

Ross

[Minty]

Make your combo with 2 columns, bring in the ID and Position and then make the column widths 0; 2

That should do what you want.

[rosscortb]

Thanks. Is this through a query rather than bringing in the whole Position History table?

[ArviLaanemets]

1. You open the form in design mode, and add a combo box, or you activate an existing one;
2. When the property sheet for combo bos is not active, activate it (right-click on combo, select Properties);
3. Activate Data tab in Property Sheet;
4. For property Row Source Type select "Table/Query";
5. Into field Row Source enter SQL string like

SELECT pt.[ID], pt.[PositionName] FROM PositionTable pt ORDER BY 2;

;
6. Set property Bound Column to 1;
7. Activate Format tab of Property Sheet;
8. Set property Column Count to 2;
9. Set property Column Widths to 0cm;2cm (the width of 2nd column may be any reasonable non-zero numeric value - it doesn't really affect anything).

That's all!