Hi,
I have a continuous form that I use to filter out checklist items, I am looking to change my category number for each category\heading when I update one of the textboxes on my form, so all other textboxes with the same heading will be the same, I am using the following code however I then meet the horrible Write Conflict message, is there a way I can always accept this as Save or not appear at all? It could be around 10 - 20 records I am looking to change at a time.
I have also tried opening another 'temporary' form that has the code and closes, however this still brings the same problem.
I also tried this code, however it wasn't that simple and only changed the one record.
Is there other ways maybe or am I missing something? My code does work, it is just the Write Conflict box that is the problem, it just makes it look untidy.
Thank you,
Malcolm
I have a continuous form that I use to filter out checklist items, I am looking to change my category number for each category\heading when I update one of the textboxes on my form, so all other textboxes with the same heading will be the same, I am using the following code however I then meet the horrible Write Conflict message, is there a way I can always accept this as Save or not appear at all? It could be around 10 - 20 records I am looking to change at a time.
Code:
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tbl_Net_Checklists SET CatOrder = Forms!frmBackground!subfrmChecklists!txtCatOrder WHERE Checklist = Forms!frmBackground!subfrmChecklists!cboChecklist AND Category = Forms!frmBackground!subfrmChecklists!cboCategory"
DoCmd.SetWarnings True
Forms!frmBackground!subfrmChecklists.Requery
I have also tried opening another 'temporary' form that has the code and closes, however this still brings the same problem.
I also tried this code, however it wasn't that simple and only changed the one record.
Is there other ways maybe or am I missing something? My code does work, it is just the Write Conflict box that is the problem, it just makes it look untidy.
Thank you,
Malcolm