SETUP
access database site with 2 tables, users & casedata

using a simple statment below how can i replace the variable 'Manchester' from a field in the users table as the page loads.

i donot want the link from the previous page to contain any search critera ie:
/results.asp?office=manchester

i only want the link to be /results.asp and the critera taken from the database as the page loads.

SELECT *
FROM casedata
WHERE office = 'Manchester'


(cross posted into SQL Forum)

triple posted - answered in sql forum

Thnaks for help

used session variable on login page to hold info, seems to work ok.