How to undo any uncommitted changes

[Bre]

Hello all,
I have a DB that allows a user to choose fruit, also they have to choose a beginning date to search the table and also a fruit. Then in a subform they can put in details for the fruit. Like if they choose grapes then in the subform they can choose red grapes/green grapes/wine grapes/ ect.. But if they try to choose red grapes in the subform with out chooseing grapes, I am having the ap throw an error telling them that they have to put in a fruit and I set the focus in the fruit field. But the choice of red grapes and the location code of the grapes is still displaying in the sub-frm fields.

I want to undo the entry into the cboBox and the txt field. How do I roll that back? I have tried me.cancel = true and a few other things, but they are not working. I could just reset the controls, but this doesn't seem like a very good option. Thoughts?
Cheers,
tebule

[MMcCarthy]

Hello all,
I have a DB that allows a user to choose fruit, also they have to choose a beginning date to search the table and also a fruit. Then in a subform they can put in details for the fruit. Like if they choose grapes then in the subform they can choose red grapes/green grapes/wine grapes/ ect.. But if they try to choose red grapes in the subform with out chooseing grapes, I am having the ap throw an error telling them that they have to put in a fruit and I set the focus in the fruit field. But the choice of red grapes and the location code of the grapes is still displaying in the sub-frm fields.

I want to undo the entry into the cboBox and the txt field. How do I roll that back? I have tried me.cancel = true and a few other things, but they are not working. I could just reset the controls, but this doesn't seem like a very good option. Thoughts?
Cheers,
tebule

Try ...

Me.cboBoxName = Null
Me.txtFieldName = Null
Me.cboBoxName.SetFocus
 

Mary