troubleshooting Question

Find by mutliple fields in Access/VBA

Avatar of ClaudeWalker
ClaudeWalker asked on
Microsoft AccessVisual Basic.NET
13 Comments1 Solution498 ViewsLast Modified:
I have a legacy table where the combination of the Owner Name, Tenant Name, Month Completed and Year Completed are the key field.

How can I search ALL of those fields simulatneously?  

Would docmd.find work?  

Or would I use a recordset that has the same SQL as the form and then iterate through until I find the record and get the Absolute Position and then use docmd.gotorecord AbsolutePosition?

The second method seems somewhat convoluted.

Thanks,
JOe K.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros