Clear form

[rrmangus]

I have a data entry form with a clear/cancel button that runs a macro to delete current data in the form. I'm having a problem when there is no data in the form and the delete button is clicked(the macro throws an error). Can anyone suggest an easy way to solve this problem?

Thanks for your help.

 

[DW]

You could pick one of your fields as a focus point and do the following in the forms current event:-

If Me.YourField = "" then Me.YourButtonControl.Enabled = False

There are may ways to do this

If IsNull (yourFieldName) then me.YourButtonControl.Enabled = False

Dave

 

[rrmangus]

Thanks! That's been bugging me for quite a while.