Refreshing Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Ron's suggestion will work. As to timing, I would suggest the form's Current
event.
Me.EachCombo = Null
 
Back
Top