Feb 11, 2007 #1 vich Technical User Joined Sep 26, 2000 Messages 107 Location 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 Joined Jul 13, 1999 Messages 644 Location 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 Joined Sep 23, 2003 Messages 11,174 Location US How are ya vich . . . . . . perhaps: Code: [blue] Me.MyCbo = Null[/blue] See Ya! . . . . . . Upvote 0 Downvote