Edit the record you are on using dao

[Ruegen]

Curious.

If I am on a form's record and it is locked because I am using it - I can't edit that record using vba and dao.recordset?

say

rs.edit
rs!field = 123
rs.update

If I do this I get a locked record.



Should I remove focus or unlock the record somehow?

[John_G]

Changing the value in a form control, either manually or using VBA, automatically changes the data in the underlying table record.

Me![controlname] = 123 in VBA is the correct syntax, no need for a recordset reference.

John

[Ruegen]

Changing the value in a form control, either manually or using VBA, automatically changes the data in the underlying table record.

Me![controlname] = 123 in VBA is the correct syntax, no need for a recordset reference.

John

Sorry to confuse however it's not the syntax.

I am on the record on the form. I click a button and it runs through the recordset with it filtering to the same record as the form. I go to edit that recordset and I get a lock error.

dim db as dao.database
dim rs as dao.recordset
set db = currentdb
set rs = db.openrecordset("SELECT * FROM qrySchools WHERE SchoolID =" & SchoolID)

so since it is going to pick up the same as the one I am currently editing the form has locked that record.

I get that I can use me. but I purposely want to use rs!

[John_G]

I get that I can use me. but I purposely want to use rs!

Why do you need (or want) to use a recordset to update the current record? You've already seen that you can't, at least not the way you are trying to do it. You could try using a RecordSetClone to update the required record, followed by a Me.Requery to update the form recordset, but I've never done that, so I don't know it it will work.