OpenForm Action and Arguments

[nkenney]

Please bear with me as I try to explain this…
I have a Customer Form with a display only (not enabled) Parts Subform. The Parts Subform has the parent child relationship setup between the parts and customer table.


I have a push button on the customer level of the customer screen to open a Parts Form to modify it for the customer. I have set up an OpenForm action with the following arguments:
Parts, Form, , "[Custid]=" & [Custid], , Normal
When I transfer to the Parts Form all of the parts are displayed and the filter appears not to execute. The bottom of the form does have the icon for the filter. Can you tell me if I am doing something wrong or if I am missing anything?

[RuralGuy]

If [Custid] is a text field then you will need: "[Custid]='" & [Custid] & "'"

[nkenney]

Actually it is a long Int. Is there something different I need to do to get this to work?

Thanks!

[RuralGuy]

Copy and Paste the actual DoCmd.OpenForm in a post here.

[nkenney]

Private Sub Add_Part_Click()
On Error GoTo Err_Add_Part_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Part"
MsgBox stLinkCriteria
stLinkCriteria = "[Custid]=" & Me![Custid]
MsgBox stLinkCriteria
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Add_Part_Click:
Exit Sub
Err_Add_Part_Click:
MsgBox Err.Description
Resume Exit_Add_Part_Click

End Sub

[RuralGuy]

SubForm is a technical term for a form that is displayed on another form by means of a SubFormControl. Your code is simply opening another MainForm named "Parts". The Master/Child relationship only works on actual SubForms, not between mainForms.

[nkenney]

only retrieve the parts for that customer?

[RuralGuy]

How does the Parts form retrieve only parts for a single customer?

[nkenney]

What I was hoping to do is to pass the customer id into the form, and use that number to query only the parts for that customer. Is it possible to do something like this? I would also like to have it available to the form so if the user presses the add part button, it will copy it into the customer id field.

Thank your for all of your help.

[RuralGuy]

Just use the OpenArgs argument of the OpenForm command to pass the customer id and watch for it in the Open event of the next form.