[AccessD] VBA Function with parameters

Borge Hansen pcs.accessd at gmail.com
Thu Nov 4 23:55:55 CDT 2021

How can I provide parameters to my own function similar to for example:

DoCmd.OpenQuery (QueryName, View, DataMode)
where DataMode is optional and can be one of these constants
acEdit (default) - which I think allows for adding as well if the
query view make it possible

So for example
function myFunction(param1, param2)

where param2 is an optional parameter with a limited set of values.
When the function is being used elsewhere in the app, I expect the
limited set of values for param2 to appear, similar to for example the
docmd.openquery ...



More information about the AccessD mailing list