custom validation message

[Crystal]

I've got a form where the recordset behind it is opened as
a snapshot. Instead of that tiny message in the status bar
that says "Recordset not updateable" I need to have a
message box pop up saying something a little more direct.
How would I do this?

Any suggestions would be greatly appreciated,
Crystal

 

[Newbie]

a msgbox in the OnLoad of the form?

something like

msgbox "Don't mess",vbExclamation,"Info"

HTH

Al

 

[Crystal]

No, that's not quite it. This needs to happen when they
attempt to make a change. The form is only opened once
per day (unless the database has to close for some reason)
so not all of the users will be able to see that message
box.

Thanks,
Crystal

 

[Newbie]

can't you just lock all the fields so that they can't enter any of them?

fieldname.locked = true
HTH
Al