Refreshing Combo Boxes

[Guest]

I've read all the posts on here and I still can't figure this out. I have a
form with four cascading combo boxes. When they press the save button, a new
record is written to a transaction table and a subform containing a pivot
table refreshes and shows the data they just entered.

To create a new record, I have the combo boxes recalc. It works, but I'd
much rather have the whole form refresh so the combo boxes would be blank.
However, all I can seem to do is refresh the subform as if I just can't focus
on the form itself. What am I doing wrong?

Sounds petty, but I don't want the users confused when the combo boxes still
have the last record's data. Everything works great on this form except that.

Thanks!

 

[Ron2005]

As long as those box values are not needed for criteria or whatever
then simply put Null into the combo boxes after you have finished using
them. Watch out for timeing.

 

[Guest]

Worked beautifully as long as I put the code in with the Save button. Thanks
a lot.

 

[Guest]

Ron's suggestion will work. As to timing, I would suggest the form's Current
event.
Me.EachCombo = Null