Main Form refresh

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hi,

I have created a form but, because one of the fields uses a keyword, the
data source is a GROUP query. i.e.......

Name Keyword_Cat Keyword
==== ========== ======
Joe Bloggs Age Group 25-33
Joe Boggs Sex Male
Joe Bloggs Referral Internet
Joe Bloggs TypeOfBiz Lawyers

Therefore, I have needed to create 3 Checkboxes - Delete, Defer & Import.
Because the main data is not updateable, I have needed to create a sub-form
for these fields which works fine up to a point.
When a checkbox is selected for say Joe Bloggs, then I run a query to ensure
that all the other records are also are updated.

I then get a message box saying:- The record has been changed by another
user since.......... etc

I have tried using the line forms.tblVBO.refresh and forms.tblVBO.requery
but I keep getting the message.

Any suggestions anyone please?

Hope I described the problem well enough.

Thanks
Simon
 
Back
Top