Hello, I'm new to this forum and relatively new to Access, so this may be a rudimentary question but I ask nonetheless.
I have a form that lists records in a report style format based on either all records or an automated filter. What I want to do is make one of the identifying controls (in this case a text box) value to become a link that will take the user to another form that filters for that specific record to view more details.
However I'm having trouble finding where to tell the control what to link to. I changed the "Is Hyperlink" property to "Yes" but there is nowhere to specify what form to open or what "Where" clause to specify for the filter.
What am I missing? I have a bad feeling I'm making it more complicated than it has to be. Any suggestions would be greatly appreciated. I'm a novice with both SQL and VBA, FYI.
Thanks!
I have a form that lists records in a report style format based on either all records or an automated filter. What I want to do is make one of the identifying controls (in this case a text box) value to become a link that will take the user to another form that filters for that specific record to view more details.
However I'm having trouble finding where to tell the control what to link to. I changed the "Is Hyperlink" property to "Yes" but there is nowhere to specify what form to open or what "Where" clause to specify for the filter.
What am I missing? I have a bad feeling I'm making it more complicated than it has to be. Any suggestions would be greatly appreciated. I'm a novice with both SQL and VBA, FYI.
Thanks!
