Opening a Form within Navigation Control

[karla.uptown@gmail.com]

I would like to open a form that displays a patient's information (PatientInformation_f) when I double click a patient's ID on a datasheet (part of another form).



I can get the patient information form to open to the right record using:

Private Sub Patient_ID_DblClick(Cancel As Integer)
DoCmd.OpenForm "PatientInformation_f", , , "PatientID=" & Me!PatientID
End Sub

However, I am using Access's Navigation Controls, and I can't figure out how to get PatientInformation_f to open within the navigation. I have read many times that all forms within navigation are considered subforms and I have tried the following but it is still not working...

Private Sub Patient_ID_DblClick(Cancel As Integer)
DoCmd.OpenForm "Form!NavigationForm_f!PatientInformation_f", , , "PatientID=" & Me!PatientID
End Sub

Does anyone know how to refer to forms within the navigation control in Access 2010?

Thanks!!!

[ssanfu]

I won't be able to look at "Access's Navigation Controls" (first I have heard about it) until tonight.
But You have a syntax error: ""Form!" should be "Forms!" (Note the "s")

DoCmd.OpenForm "Forms!NavigationForm_f!PatientInformation_f", , , "PatientID=" & Me!PatientID

If you have a button that currently opens the form "PatientInformation_f", add the same code in the double click event of the patient ID control and add the WHERE clause.

[karla.uptown@gmail.com]

Thanks for the response... I tried using Forms!..., but it still doesn't work.

It says "Forms!NavigationForm_f!PatientInformation_f" is misspelled or refers to a form that doesn't exist. Since the form names are correct, I have to assume that this isn't the correct way to refer to a form within the navigation window.

I think this code will work if I can figure out what to call the form as it sits in the navigation window. Any ideas?

I won't be able to look at "Access's Navigation Controls" (first I have heard about it) until tonight.
But You have a syntax error: ""Form!" should be "Forms!" (Note the "s")

DoCmd.OpenForm "Forms!NavigationForm_f!PatientInformation_f", , , "PatientID=" & Me!PatientID

If you have a button that currently opens the form "PatientInformation_f", add the same code in the double click event of the patient ID control and add the WHERE clause.

[ssanfu]

Would you like to post the dB so I can look at it tonight and see the forms?

[karla.uptown@gmail.com]

Sure! It is attached. The code is in the patient ID field of SubFormPatientSearch_f. I am trying to open PatientInformation_f with in NavigationForm_f.

Thanks!!!

[rpeare]

can you post a sample that's 2003 or earlier. If you are referencing a subform on a main form you can't use forms!<formname>!<fieldname> same goes for referencing a main form item from a subform the referencing string is different:

If you're referencing a subform from a main form it's something like:


Forms!mainform!subform.Form.controlonsubform