Hyperlink to open a form

[accessnewb]

I have a search button and onClick of the search button a query is executed and filters the results in datasheet view. Is it possible for a field in the datasheet view to have a hyperlink and when I click on it, I should be able to view the corresponding form? (the form is also in the same db) Imagine the hyperlink is for the field strEmpID, then when I click on a particular field, based on the strEmpID, a form should open.


When I googled for hyperlinks in access, most of the websites talk about linking to an external file or a webpage. Is there any way to open a form in the same DB?

[June7]

Wrong approach. Use double click event of the form displaying the datasheet view to run code to open form. Like:

Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "form name here", , , "filter criteria here"
End Sub

Open the same form for all records but filtered to the one EmpID? So filter criteria would be like:
"strEmpID='" & Me.textboxname & "'"

User would double click in the left margin of record to trigger this event.

[accessnewb]

umm..doesn't work? Maybe I totally misunderstood what u said, but my understanding is: let's say I have a form called "products" which has a search button and onClick of this button, a query is executed and the results are filtered in datasheet view. So on the doubleClick event of the form "products", I gotta write the code you have given? I did that and I tried clicking the left margin of the filtered results and nothing got triggered!

[June7]

The filtered results are on the same form as the search button? Or is this a subform? Post all relevent code for analysis.

[accessnewb]

The filtered results are in another form. I have another form called frmSearchResults and this form is linked to a query. So when I click on the products form, the query is triggered and frmSearchResults open with the filtered results. This is what I coded:

Private Sub Form_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmSearchResults ", , , "FPItem='" & Me.FPItem & "'"
End Sub

this code is in the double click event of the 'products' form

[June7]

If I understand, this is what needs to happen.

1. Click button on Products form. Code in button Click (not form DoubleClick) event to open frmSearchResults. Or eliminate the button and use AfterUpdate event of the control where the FPItem is selected (a combobox?).

2. DoubleClick on record in frmSearchResults to open another form filtered to specific employee ID. It is behind frmSearchResults where my suggested code belongs.

[accessnewb]

oh cool it works now! But instead of double clicking the left margin, can I double click on the field? Maybe have a hyperlink on the field? My worry is that the users are not gonna know that this is a clickable datasheet.

[accessnewb]

hey figured it out! Instead of coding in the doubleClick event of the form, I coded on the click event of the field in the frmSearchResults form. I also made that field into a hyperlink, so now it works like a charm!

[June7]

I don't think hyperlink will work to open objects within the project. The controls have Click and DblClick events. Try the code there. Is frmSearchResults locked against editing?

Congratulations! I was composing reply just as you posted. Not sure how having the field as a hyperlink contributes to this success.

[Access_Blaster]

Hi June7,

Are you saying that hyperlinks will not open objects (Forms, Tables, Querys) and paths within a database? Or am I missing your point.

[QUOTE=June7;69451]I don't think hyperlink will work to open objects within the project. The controls have Click and DblClick events. Try the code there. Is frmSearchResults locked against editing?

Richard

[June7]

I am saying I don't understand how a hyperlink could. If you or someone else knows otherwise, please explain.

[Access_Blaster]

I am saying I don't understand how a hyperlink could. If you or someone else knows otherwise, please explain.

Sure, I use the Hyperlink dialog box from the insert menu in design view Ctrl+k. In the left pane of the dialog box I select "objects in this database" No big deal I thought this was common practice.

[June7]

Interesting, I was trained to use VBA to open forms and reports. Filtering criteria is passed to the form/report when it opens. I don't build reports/forms with a lot parameter criteria. I presume your forms/reports opened by hyperlink have parameters that refer to the calling form to get filter criteria?