Requery not working

[topdog]

Hi, I'm trying to requery a combo box using the On Enter event. It
used to work fine in my other projects. The combo box is on a
subform. I used to simply put controlname.requery in the On Enter
event but it's not working. I have even tried
Forms!MyMainForm!MySubForm.Form![MyControlName].Requery

Any ideas what I'm missing?
THanks

 

[Chaplain Doug]

Did you "cut and paste" or "copy and paste" this combo
control from another form? I have had this happen when I
did that and found the only way to remedy the problem is
to rebuild the combo control using the combo wizard.

 

[Guest]

Hello,

When you copy a control. I believe you need to copy the code as a separate
action. the code doesn't automatically come with the control.

Did you "cut and paste" or "copy and paste" this combo
control from another form? I have had this happen when I
did that and found the only way to remedy the problem is
to rebuild the combo control using the combo wizard.

-----Original Message-----
Hi, I'm trying to requery a combo box using the On Enter event. It
used to work fine in my other projects. The combo box is on a
subform. I used to simply put controlname.requery in the On Enter
event but it's not working. I have even tried
Forms!MyMainForm!MySubForm.Form![MyControlName].Requery

Any ideas what I'm missing?
THanks
.