Subform Button to Open another Subform

Question

Hello,

I have a button embedded in a subform to open up a modal window. This works well if I just open the subform and click the button. It opens to the correct record to display. However when I have the main form open with the embedded subform it displays a #NAME error in the control record field.

I'm not sure how to link through each form to get the control to work.

Currently the macro language is:

Form Name: Sample_Form

View: Form

Filter Name: 

Where Condition = ="[Serial Number]=" & "'" & [Serial Number] & "'"

Data Mode:

Window Mode:

The control source for the control record is

=[Forms]![Sample_Table_Subform]![Serial Number]

Thanks for any assistance :)

Answer 1

Because you are trying to reference a sub form when you open your other form, the system does not recognize "[Forms]![Sample_Table_Subform]![Serial Number]."  To reference a field or control on a sub form, you need to use the syntax: Forms![Parent Form Name]![Sub Form Control Name].Form![Serial Number].

However, because your button is located in the sub form, you need only do the following using VBA instead of a Macro:

Private Sub YourCommandButtonName_Click()

    If (Not IsNull(Me.[Serial Number])) Then

        DoCmd.OpenForm "Sample_Form", , , "[Serial Number]='" & Me.[Serial Number] & "'"

    End If

End Sub

Answer 2

Thanks for the assistance again! I was sure that it had to be something like that but couldn't find a reference in my searching.

Thanks!

Answer 3

And what is the name of the subform control?

Answer 4

Yes the button is on the embedded subform, I moved some information off of the subform to the subsub form and hid it with a button. 

User_Information is the main form with the primary key being [User_Information]![User_ID] each user has x serial numbers assigned to them which are displayed in the subform with relative information and is designed to navigate only to serial numbers assigned to that User.

Answer 5

Is this button on the embedded subform? Is Serial Number a control on the subform? what is the name of the main form and the name of the subform control?