Feb 11, 2007 #1 vich Technical User Sep 26, 2000 107 US I have searched and can't seem to find a way to clear the combo box after aborting a change in the beforeupdate event. I am using me.mycbo.undo cancel = true While the operation aborts it still keeps the item selected in mycbo box. Can't I clear that? Thanks
I have searched and can't seem to find a way to clear the combo box after aborting a change in the beforeupdate event. I am using me.mycbo.undo cancel = true While the operation aborts it still keeps the item selected in mycbo box. Can't I clear that? Thanks
Feb 11, 2007 #2 CaptainD Programmer Jul 13, 1999 644 US Setting the rowsource to "" will clear the items that were added. Setting it's value should clear all entries Code: Me.Combo0.RowSource = "" Me.Combo0.Value = "" Upvote 0 Downvote
Setting the rowsource to "" will clear the items that were added. Setting it's value should clear all entries Code: Me.Combo0.RowSource = "" Me.Combo0.Value = ""
Feb 11, 2007 #3 TheAceMan1 Programmer Sep 23, 2003 11,174 US How are ya vich . . . . . . perhaps: Code: [blue] Me.MyCbo = Null[/blue] See Ya! . . . . . . Upvote 0 Downvote