Update a record using recordset

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I want to update a record using recordset method with VBA. How...?? Thanks.
 
Like

Me.Form.Recordset.Fields("MyField") = "New value"

which is the same as

Me!MyField = "New value"

Perhaps you could state your goal more specifically to avoid replies as
general as the question.
Cheers,
Pavel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loading recordset at runtime 4
Update a read-only recordset 4
Returning whole recordset based on selection from combo box 2
Moving to a Record after the Key has been changed 1
Addnew followed by Edit 2
Error 87 When Creating Large Email Distribution List 1
Access 2007 Tabbed form with shared recordset 0
Filter main form to records with no related records in subform,maintain updateable recordset 4

Back
Top