Linking combo box to subform?

[NewShoes]

Hey all,

Very simple question probably but my mind has gone blank! ...How do I link a combo box on a form (contains employee number) to a subform on the same form?

I.e. I select 12345 from the combo box and only employee 12345's records will be shown in the subform. Also, If possible, I dont want the employee number to be set as a combo box in the field settings.

Many thanks in advance!
-NS

 

[Scooterbug]

For the combo box, put in the employeeID and the employee name for the row source. You dont have to have the ID display (In the properties of the combo box, set the column width to 0). Then use the combo box as the Parent field and the employeeID in the subform as the Child field.

 

[NewShoes]

Thanks scooterbug, i'll give that a go tomorrow

-NS

 

[RossWindows]

For the combo box, put in the employeeID and the employee name for the row source. You dont have to have the ID display (In the properties of the combo box, set the column width to 0). Then use the combo box as the Parent field and the employeeID in the subform as the Child field.

Wouldn't the Column Widths property on the combobox be something like:

0";1.5"