I want my Listbox to update when I put a new name in.

[cowboy]

I have a listbox that lists the name of all my records, I want that when I change a name or add a name it does it instantly. At the moment I have to switch to another record for it to update.

The listbox Row Source for lstDI:
SELECT InspectionsDI.ID, InspectionsDI.[MN12] FROM InspectionsDI ORDER BY InspectionsDI.[MN12];

When I type a new name in textbox txtMN I have in the after update code:
Me.lstDI.Requery

That doesnt do the trick, and it does call the requery because I put a breakpoint on it to make sure. Any ideas?

[pbaldy]

At a guess, I'd say the record currently on the form isn't saved yet. Try adding

DoCmd.RunCommand acCmdSaveRecord

before the requery to force it to save.

[TheShabz]

also try me.refresh after your me.requery if the above doesnt work out.

[cowboy]

Worked with just the save.