unbond combo box initial value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound combo box that is used to select an employee - it work fine
except when I open the form, the combo is blank, but the form's other fields
are filled in for the 1st row in the table. I would like either:
- to have the fields all blank until the combo box is used to select an
employee
- to have the name in the combo box set to the value of the 1st row when the
form opens.

I am using MS Access 2000.

Thanks, Lisa
 
Set the form's RowSource to "", and nothing will show up when you open the
form.

In the code that you've got in the combo box's AfterUpdate event to display
the details for the selected employee, set the form's RowSource to the
appropriate value before proceeding.
 
Back
Top