Refresh a combo box after adding a record

Question

Community,

I know these are easy for experienced Access developers, but I am not one. I have a combo box (Part Number) on a form and I have a form to add a new part number.

The Add Part Form is:

I am just trying to update the Combo Box with the added record. I image it is a Requery or Refresh of that combo box in the Save and Close macro, but can't get the syntax correct. The form is frmPartTracker and the Control Name is ComboPartNum.

Answer 1

Thanks Tom, I'll look into that.

John

Answer 2

Thanks, I'll look into that.

Answer 3

Actually, better than that is the use of List Items Edit Form in combination with Allow Value List Edits. This is an almost zero code replacement of the NotInList event.

Answer 4

Interesting, I just worked on this myself last Friday.

My first instinct was: Forms!frmPartTracker!ComboPartNum.Requery

But what that does is get a fresh value of PartNum, and thus possibly selecting a different item in the dropdown list.

To requery the list itself, I used:

Forms!frmPartTracker!ComboPartNum.RowSource = Forms!frmPartTracker!ComboPartNum.RowSource

The new item then showed up.

Answer 5

I suggest you do some research on the NotInList event of comboboxes. This is the better way to enter new data.