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.