In this single-user app I have a form with members. In the related table I
have a field 'Select' with which the user can select a record. I have two
buttons on the form (All and None) that select either all records or none.
Those buttons both work with an edit query. It works except for the current
record since that is locked. To avoid that I have added code that
specifically changes the Select value of the current record by Select=-1 (or
0). It works but the only annoying thing is that after the query Access
shows a dialog box "Info has been changed" with an OK button. What can I do
to avoid this button?
thanks,
john