requery combox after saving a record

[szag via AccessMonster.com]

This should be easy but I don't know what I am doing wrong:

I have a combobox "cboxDate". On click I want it to save the current record,
then update the combox's underlying query (so it incorporates any new
selections from the "Date" field on the form). The "date" field on the form
should then be incorporated into the combox's selections. I can't get this to
work - It just keeps the old choices. If I close out of the form then come
back in obviously it is updated like it should be.

My code for On Click:
DoCmd.RunCommand acCmdSaveRecord
Me.cboxDate.Requery

 

[szag via AccessMonster.com]

answered my own question - OnGotFocus was the event to use - OnClick must be
too late...