Combo box not updating

[RaptureReady]

Hello all, I am new here so please excuse the noobness.

What I have is a entry form with 20 or so fields that has a members info such as name, street, city, etc.

I enter the info, click add or save record, it does that, but when I go to select it from the combo box, that record is not in the drop down.

Obviously when I close the form and go back into it, is is there. I was wondering if someone can give me the code to make it work without going out of the form and then back in.

I tried to do a docmd.requery [controlname], but did not work.

Any clues anyone?

Thanks,
RR

 

[rainman89]

put this in the onclick of your save button or in the afterupdate of your form

comboboxname.requery

 

[RaptureReady]

Hey thanks for the reply. I actually took the code from the refresh wizard that you do when you create a command button.

RR