Creating a hyperlink on a data access page using a field from a query

[Guest]

Can I create a hyperlink on a data access page using a field from a query? For example, let's suppose I have a query q_employee_data that gets the employee name, employee ID, and employee gender from the t_employee_data table.

Using that query, I create a report, r_employee_data that prints out the info. I save it as a DATA ACCESS PAGE. I want it so the following happens:

This info comes back from my query:
Employee ID Employee Name Employee Gender
123 John Doe Male
456 Jane Doe Female

And when I go to the data access page and click "123", I am taken to http://hr.company.com/?employee=123.

Is this possible? I know it will probably need to be done in VBA. Could someone write a sample I could look at (I'm a newbie and can't afford a book).

Thanks!

 

[Guest]

In your data access page, You can create a hyperlink with the source of your queryfield......
(Just create the hyperlink and without click any source click ok.)
Than in the properties of your link, on the 'anchor' tab, select the wanted 'datasource'......