Custom Message

[Sky Warren]

Hello All,

I have a form that displays a table which has been locked from Editing and
is for display purpose only. I would like to have a custom message appear if
a user clicks in any of the fields to attempt any kind of editng.

I tried writing events in the OnClick event for each field, but I have to
many fields and it seems like overkill. Is there a way to write one procedure
that will popup a message if any field is clicked on?

-Sky

 

[Penguin]

Yes, first create a new procedure in a module. Add you message box
code then have all your fields call that procedure.

 

[PC Datasheet]

You don't need a message! For all the fields, set the Enabled property to No
and the Locked property to Yes and the users will not be able to enter the
fields.

 

[Sky Warren]

Thanks to Penguin and PC Datasheet. Your both correct. Penguin, I created a
sub form with the MsgBox function and then called that procedure from the
OnClick's and it works great. Thanks again!

-Sky