Trigger MsgBox when user tries to change data in a read-only recordset

[lastout]

I have a subform on a main form that shows the results of a query. The records are read-only. If the user perchance tries to edit any of the records in the subform, I would like to have a MsgBox popup telling them they can't edit there (similar to the msg you get in a query window when you try to edit a read-only recordset) and telling them what to do if they want to edit, etc. Problem is, I don't know what event to use to trigger the MsgBox. Does anyone have a suggestion? lastout (the game's not over till it's over)

 

[VivP]

I wouldn't bother, if I were you. Just set the Enabled property to False and the Locked property to True on the boxes displaying the data or on the whole sub-form. Then they will quickly get the idea. Viv Paton
Access Developer