VBA sql to edit specific information

[Ruegen]

Would it possible to put criteria on an sql in vba?



I require to change a checkbox but because the query is locked due to having more than one many to many junction in the record source I can't edit the details

however if possible I would like vba to look up the record, then edit the details using vba

I thought maybe if I can use sql in vba then I might be able to edit the details providing there is criteria to only edit that one.

possible?

[June7]

Yes, VBA can execute SQL actions.

CurrentDb.Execute "UPDATE table SET somefield=something WHERE afield=this"