[AccessD] VBA Function with parameters
paul.hartland at googlemail.com
Fri Nov 5 00:00:37 CDT 2021
See answer at bottom of this link, is this what you are after ?
On Fri, 5 Nov 2021, 04:56 Borge Hansen, <pcs.accessd at gmail.com> wrote:
> 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 ...
> AccessD mailing list
> AccessD at databaseadvisors.com
> Website: http://www.databaseadvisors.com
More information about the AccessD