Need to only access filtered recordset

[arage]

My form currently filters based on certain selection criteria in the sql query builder. The form’s vba code uses some functions like Dmax, dlookup etc….functions in which I have to re-specify filter conditions otherwise the entire domain is searched, as opposed to the filtered recordset behind the form.

I’d like my functions & procedures to only access the filtered recordset, how can I do this?

 

[A real begineer]

You could create a query which filters the recordset, and populate your form from this.

In your procedures and functions, you would refer to the query in your dlookups, or dmaxs.