Access module from inputparameters

  • Thread starter Thread starter robinhermanussen via AccessMonster.com
  • Start date Start date
R

robinhermanussen via AccessMonster.com

Hi,

I need to access a variable in a module (basGlobal) for use as an input
parameter for a form's stored procedure. I've tried using:

@an_input_param T_id=[basGlobal].[globalInputValue]

T_id is a SQL Server custom datatype. I've also tried some variations.

However, a popup asking for a value keeps coming up.

Does anyone know how to make this work? How could I do this in VBA
(alternatively) and what event should I use?

Thank you very much.
 
You can create a public function that returns the value of the global var.
Functions are accessible to queries where variables are not.
 
Back
Top