I have some global variables.
I use this variables to open a form based on a query with parameters.
Now I use the On Load event to prepare an SQL string which include values of the global variables then: FORM.RecordSource = SQL .
Works fine but, if I wish to make changes is a hard work.
The question is: Is here any way to pass values directly to the RecordSource query ?
The same question for a ListBos RowSource.
The link criteria using with DoCmd.OpenForm is not an option.
Thank you !