Public variables and input parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

In a form i use a stored procedure as data source. The procedure takes two
input parameters. I want to use the value of two public variables that I have
defined in the application as input parameter and specify this in the Input
Parameter property of the form. Can this be done in Access? If yes: how? If
no: What is the alternative?

Thanks for any assistance!

/Leif S.
 
Public variables are accessible only in code.
You can expose them with a function.

Example:
Public gstrReportFilter As String
Public Function ShowReportFilter As String
ShowReportFilter = gstrReportFilter
End Function

You can now use ShowReportFilter() in the query.
 
Back
Top