Declaring variables 1

[Tronsliver]

I'm using a class module attached to a specific form. My intent is to build a number of functions to search a query for information. How can I declare the recordset so its scope is visable to all functions?

Dim rst As Recordset

Set rst = CurrentDb().OpenRecordset("qryAuth/Ass", dbOpenDynaset)

Thanks

 

[Ed2020]

You can't in a class module behind a form.

You need to create standard module or custom class to make the scope public.

Ed Metcalfe.

Please do not feed the trolls.....