Var's lost on refresh - help

[Matt]

I have pg1 sending 6 vars to page2.

Page2 uses the 6 vars to pull from an access database the
fields of a specific tbl. under the sql stmt a function
displays the records with headers, which will be sortable
and pgable.

Problem is this. - The initial load is fine with sortable
hdrs and pgable pgs.
BUT when the user clicks on any header to sort or next pg,
then the vars are lost and the sql stmt is emptied.

Is there a way to hold the vars, or convert them easily to
a hardcode type string?

any help would be greatly appreciated

[Matt]

I have pg1 sending 6 vars to page2.

Page2 uses the 6 vars to pull from an access database the
fields of a specific tbl. under the sql stmt a function
displays the records with headers, which will be sortable
and pgable.

Problem is this. - The initial load is fine with sortable
hdrs and pgable pgs.
BUT when the user clicks on any header to sort or next pg,
then the vars are lost and the sql stmt is emptied.

Is there a way to hold the vars, or convert them easily to
a hardcode type string?

any help would be greatly appreciated

[Randy R]

> Is there a way to hold the vars, or convert them easily to

> a hardcode type string?

You could pass the variables in a querystring when the user clicks on a
header name. Or, use session variables to hold the values.

[Randy R]

> Is there a way to hold the vars, or convert them easily to

> a hardcode type string?

You could pass the variables in a querystring when the user clicks on a
header name. Or, use session variables to hold the values.

[Matt]

Thanks I figured out the session vars - thanks again