temporary variables and combo box

[Jen0dorf]

Hi



I have a combo box setup to list parishes and a button

The in click action is a macro

SetTempVar

name: varParish

Expression: [cboParish]

where the combo box has the name cboParish.

It does not seem to function when I run my query.

Can you use a combo box to do this? Do I have to set the format of the combo box?

Is there a way so seeing if the temporary variable is created OK?

thanks

Ian

[davegri]

Don't know about the macro code, but if you want to see the value of that tempvar go to the VBE Immediate window and type:
?tempvars!varParish. If it shows NULL, then it has no value.

[Jen0dorf]

Hi

thanks for that I now know my issue is with the variable setup

cheers

Ian