resetting a txt box contents after error

[Jaymin]

i have a txt box which is a required field, i have a dlookup to check if this data has already been entered, if not it continues on if it has the focus is reset to that txt box, but the entered data is still able to be seen, is there a way of removing this data so the txt box is clear, i cannot use null or "" because it comes back an error as this is a required field and cannot be null or empty.
Peter :banghead:

 

[bob fitz]

Re: resetting a txt box contense after error

Have you tried:
Me.ActiveControl.Undo

 

[RainLover]

Re: resetting a txt box contense after error

Why not simply set "Allow Duplicates" to no.

 

[Jaymin]

Re: resetting a txt box contense after error

RainLover and Bob fitz,
Thanks for your help
Peter