Richard, as a work-around solution for the issue with the command button wizard problem that I ran into, I went into the Build Event property and changed the code.

For anyone that runs into this same issue, here's what I did:

I created a command button on the ProductSubF to open all records. This at least allowed me to get a working command button onto ProductSubF. Remember, I couldn't open specific records because the ProductSubF fields were not appearing in the left pane in the command button wizard.

I then accessed the code behind the command button throught the BuildEvent property.

I compared this code to the code for a working command button that would open a specific record on a form from a command button on a subform.

I deleted all of the code for the command button on the ProductSubF and brought over the working code for the other forms.

I made name and reference changes where needed. Here's the code:

Private Sub OpenSelectedProductButton_Click()
On Error GoTo Err_OpenSelectedProductButton_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "ProductF"
    stLinkCriteria = "[ProductID]=" & Me![ProductID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_OpenSelectedProductButton_Click:
    Exit Sub

Err_OpenSelectedProductButton_Click:
    MsgBox Err.Description
    Resume Exit_OpenSelectedProductButton_Click

End Sub

I would still be interested to know why the fields aren't/weren't visible in the left pane of the command button wizard.

M.

---

Reply from Richard Rost:

This may work, but you shouldn't have had to do it. This is way beyond Expert 8 material, and I wouldn't have shown it in class if this was required. Something else went wrong while you were creating your button.