combo box won't clear

[dpdeleon]

I have a combo box which I populate by setting the row source to a sql
statement. Whenever I call the form containing said combo box the combo box
retains the previous entry even though the sql statement has properly
executed and contains the correct values.

How can I clear this combo box?

 

[larry]

-----Original Message-----
I have a combo box which I populate by setting the row source to a sql
statement. Whenever I call the form containing said combo box the combo box
retains the previous entry even though the sql statement has properly
executed and contains the correct values.

How can I clear this combo box?



.
try running a requery macro on the forms on open event