Clear Field on Error

[jibb]

Hello All,

Probably an obvious one...I have got a form with a couple of dlookups on it, when they return an error it pops the debug message up and if there is a value in the field already it just leaves that value there.
How can I supress the message and clear the field and move on to the next line of code?

Thanks

 

[JHB]

Set the forms On error property to "[Event Procedure]".
Then insert the below code.

 Private Sub Form_Error(DataErr As Integer, Response As Integer)
  Me.YourFieldName = ""
  Response = acDataErrContinue
End Sub

 

[jibb]

Thanks.

There are 4 fields which have a dlookup that can show the error but I only want to clear the fields that show the error - is that possible?

 

[JHB]

When do the error pop up, by form open/load, when you go to the next record or ...?

 

[AlexHedley]

Wrap the DLOOKUP() in an NZ()?

 

[jibb]

I'll try explain better...
It's a lookup form for customer pricing - some customers have up to 4 price breaks but if there isn't a price it currently tries to debug and if you just click end it stops any of the rest of the price lookups working.

 

[missinglinq]

Alex's suggestion is what I'd try:

Nz(DLOOKUP(),"")

If DLookup returns a Null, the Control will be populated with a Zero-Length String.

Linq ;0)>