[AccessD] VBA Function with parameters

[Borge Hansen]

Hi,
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
acAdd
acEdit (default) - which I think allows for adding as well if the
query view make it possible
acViewOnly

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 ...

??

/borge