I have a recordset created and held in a public variable while bouncing through some userforms.
One of the options I have is an uprevision of the data and I want to use recordset.find to prefill some of the fields in a userform for adding records.
The error I get is as described highlighting the ".find"
I am hoping this is just a syntax error because I do not want to have to loop through the recordset as an array.
Please Login or Register to view this content.
Last edited by Leon V (AW); 10-25-2022 at 08:52 PM.
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
I don't think the Find method returns anything - it should just find the next matching record or set EOF if nothing is found. You can then query the recordset to retrieve the data you want.
See here for an example: https://learn.microsoft.com/en-us/sq...l-server-ver16
WBD
Office 365 on Windows 11, looking for ✶ rep!
Maybe something like this.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks