Filter a table using VB

F

fugitive

Joined
Feb 3, 2006
Messages
2
Reaction score
0
Hi,
I'm trying to figure out a way I can update a specific record in a table (let's call it table1), using a form that is in no way linked to table1

I was hoping I'd be able to do something like this:

With currentdb.openrecordset("table1")
.filter="transactionid"=&strTransID
.Edit
.Fields(12).value = True
.Update
End With

But Access kicks up a fuss and says "operation is not supported for this type of object" (referring to the .filter line)

Any ideas what I could do as a work around?
 

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

Filter Field Selection from Previous Field 2
Multiple pivot tables on same sheet with common report filter 1
Run time error "table opened exclusively" 2
Need combo box to refresh when moving to new record 2017 1
Filtered Records as source for appending records to a table 1
Use a variable to set a reference to an Access table object 2
update query (how to update record based into another table?) 2
Simple Entity Framework copy records operation, or so I thought? 2

Top