Hi.
I have in my DBC set up a parameterised view with a variable as follows:
?lnMyVar = Myfield_PK (in the filter section)

I then want to requery the view on a form and I do the following:
Select MyView
lnMyVar= MyAlias.MYPK
Requery()
Thisform.refresh()

Now this all works fine , but the only way I can get it to work is if I declare lnMyVar as a Public Variable. (Otherwise the minute the form is run, it comes up with a message asking me for a value to put into lnMyVar)

Is there a better way of handling this, without haviong to declare the variable as public ?

Regards,

Gerard