G
Guest
I currently have a form with a combo box that displays employee ids. The
source for the combo box is a query on table employees. I also have a subform
which is bound to table employees. I control the records displayed in the
subform using the combo box by setting the LinkMasterField and LinkChildField
of the subform. This all works fine. What I would like to do is use the
subform for both displaying existing records and adding new records. I would
like to have a blank or null value in the combo box that the user can select.
Once the blank employee id is selected the subform would then accept values
for a new record.
How can this be coded? Your reply would be appreciated.
source for the combo box is a query on table employees. I also have a subform
which is bound to table employees. I control the records displayed in the
subform using the combo box by setting the LinkMasterField and LinkChildField
of the subform. This all works fine. What I would like to do is use the
subform for both displaying existing records and adding new records. I would
like to have a blank or null value in the combo box that the user can select.
Once the blank employee id is selected the subform would then accept values
for a new record.
How can this be coded? Your reply would be appreciated.