Requery not update until 2nd record?

[Sheila D]

I have a combo box which needs to refresh after each record is added, I have
the After Update Event set to Me.Manufacturer.Requery (with help from a
previuos post)

I have an odd success with this whereby if I add a new value in a record the
combo box does not refresh immediately, it only refreshes when I add a second
record

ie if I add Fred to the list the next record does not show Fred in the
dropdown but if I add another record (with the same or different value) then
the drop down refreshes to show Fred.

I previously had this set to
Private Sub Manufacturer_AfterUpdate()
DoCmd.Requery "Manufacturer"
End Sub
Which worked fine in Access 2007 but not in Access 2000 which is what I need
for the time being. Any help much appreciated.
Sheil

 

[Klatuu]

With the requery done in the After Update of the combo, it will only requery
when you change the value in the combo manually. The After Update event of a
control does not fire if a value is entered programmatically.

If you need the combo to requery for each new record regardless of whether
you change the the value in combo, you would need to requery the combo in the
After Insert event of the form.

 

[Sheila D]

Dave

That's great, thanks so much

Sheila

With the requery done in the After Update of the combo, it will only requery
when you change the value in the combo manually. The After Update event of a
control does not fire if a value is entered programmatically.

If you need the combo to requery for each new record regardless of whether
you change the the value in combo, you would need to requery the combo in the
After Insert event of the form.