Custom Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Yes, first create a new procedure in a module. Add you message box
code then have all your fields call that procedure.
 
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.
 
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
 
Back
Top