Full Version: Hyperlink
UtterAccess Forums > Microsoft® Access > Access Forms
Hi All,

I have several forms one being the main. I'd like to be able to click on a person's name in the main form and it takes me to that person's contact info. The name in the contact form is connected to the main form using a combo box. Below is the code:

SELECT [Social Worker].[Social Worker No], [Social Worker].[First Name], [Social Worker].[Last Name], [First Name] & " " & [Last Name] AS Fullname, * FROM [Social Worker] ORDER BY [Social Worker].[Last Name];

Thanks much!
Not clear what you want. If you want to popup a form with the person's details, then Use the WHERE clause of the OpenForm method. But it would be easier to put a subform on your mainform linked on Social Worker No.

BTW, it is NOT a good idea to use spaces in object names, this can come back to haunt you. Use CamelNotation or underscores.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.