Updating a record source of a combo box after creating a new record

  • Thread starter Thread starter CQMMAN
  • Start date Start date
C

CQMMAN

Hello,

I have a combo box that reads from a table. When I select a record in the
combo box and save it as a new record, it means that it cannot be selected
again from that combo box. If I close and open the form again, it works,
that entry is not visible. If I just create a new record, it still is.

Is there anyway that I can refresh the data in the drop-down list in the
combo box whenever a new record is created?

Cheers
 
| Hello,
|
| I have a combo box that reads from a table. When I select a record in the
| combo box and save it as a new record, it means that it cannot be selected
| again from that combo box. If I close and open the form again, it works,
| that entry is not visible. If I just create a new record, it still is.
|
| Is there anyway that I can refresh the data in the drop-down list in the
| combo box whenever a new record is created?
------------
Did you intend to disable the combo box once the new record has been saved?
If so, you can set the Enabled property of the combo box control to False
in the AfterUpdate event of the form.

Hope this helps,
 
Back
Top