If Control Exists Then Yes Else No

[zevw]

Is there a function Like NZ which will do the following!

If the control exists on this form then send this message otherwise do the other. I need this for error trapping.

Any help would be greatly appreciated.

 

[PHV]

Something like this ?
On Error Resume Next
If UCase(Me(strControl).Name) = UCase(strControl) Then
MsgBox "this message"
Else
MsgBox "the other message"
End If

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[zevw]

I"m sorry but what does strcontrol represent

Lets say strcontol = CustomerId

What I am trying to check if the control customerid exists in this form or not if it does not exist it will give you an error.

 

[PHV]

Try something like this:
On Error Resume Next
If Me("CustomerId").Name <> "CustomerId" Then
MsgBox "error message"
End If


Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244