unbound combo box shows no value on open

[smoeller]

I have an unbound combo box in a subform to select a project. This subform
contains another subform, that show all the project member. When opening the
main form, the project member of the first project are listed, but the combo
box is empty. I can click the drop down and do see all projects listed and
when selecting a project, it show up in the combo box.
Any ideas how to show the the first projectname when opening the form?
THANKS in advance!

 

[Ken Sheridan]

In the subform's open event procedure put:

Dim ctrl As Control
Set ctrl = Me.cboProject

ctrl = ctrl.ItemData(0)

where cboProject is the name of the combo box.

Ken Sheridan
Stafford, England

 

[smoeller]

THANKS, Ken! It works!!!

In the subform's open event procedure put:

Dim ctrl As Control
Set ctrl = Me.cboProject

ctrl = ctrl.ItemData(0)

where cboProject is the name of the combo box.

Ken Sheridan
Stafford, England