Form-how not to get the data of previous record

[CAJ]

Hi,


Ive made a form. The form has quite a few combo boxes in it based on tables. A big problem that I cant seem to solve is that when I enter a new record in the form, it remebers and pre-filles the value of the previous record in the combo boxes. I have tried several things like default value in the table as well as in the form but this does not fix the problem. My form is quite useless when it prefills the values from previous records. Any one a idea on how to solve this??

[tdecker81]

requery all of them in the oncurrent event. Give it a try and let me know.

[CAJ]

Thanks so much for reply! Just not sure what you mean with 'requery them all'. Would you mind explaining.

[tdecker81]

open the form in design view. with the form object selected click on events. Near the top of the list you should find the on current event. Click in that box and then click the ... and then pick code
in the code block once it opens type

me.comboboxID.requery

replace comboboxID with the name of each combo box and repeat the code until you've listed all of your combo boxes.

Then give it a try.

[CAJ]

AWESOME!!! Fixed it! So happy. Thanks heaps!