MS Access Forms: navigating between forms

[InspectorHound]

I am creating an MS Access 2013 desktop application and need some help. I have created a continuous form that is based on a query that has five fields. The five fields are displayed in the detail section in tabular style. The header of the form has three unbound textboxes, related to three of the five query fields where users can search the query. When the user types in a name or SSN and hits search, the records related to that person are displayed in the detail section.

I now need to select one of those records in the detail section and have information from another table displayed. What is the best way of doing this. Should I open a new form?

 

[MajP]

Yes. Use the where condition of the Docmd.openform

http://msdn.microsoft.com/en-us/library/office/ff820845(v=office.15).aspx

you could add a double click event to the five fields in the tabular detail section, or just a cmd button in detail section. Then call the docmd.openform method.

 

[InspectorHound]

Ok, I created a hyper link field and am using its on Click property, but nothing is happening. Here is my code:

Public Sub AuthLinkedProfileID_Click()

MsgBox " Hello "

If Not IsNull([AuthLinkedProfileID]) Then

DoCmd.OpenForm "frmVouchers", acNormal, , "Forms![frmVouchers]![LinkedProfileID] Like ""*" & [AuthLinkedProfileID] & "*"" ", acFormReadOnly, acWindowNormal

End If

MsgBox " Hello "
End Sub

 

[MajP]

your where condition does not make any sense. Should be something like
"someFieldInOpeningForm = " & someValueOnCurrentForm

LinkedProfileID = " & [AuthLinkedProfileID]
or if text
"LinkedProfileID = '" & [AuthLinkedProfileID]& "'

 

[InspectorHound]

Ok, I tried that. Thanks. The problem now is that when I click on the hyperlink in the textbox, the code does not run.

 

[MajP]

If Msgbox "hello" does not appear then you need to verify that you have [event Procedure] selected in the onclick property of the control.

 

[InspectorHound]

I did that, but I still get nothing

 

[InspectorHound]

It works! Thanks!