Form with parameterized query

[ngruson]

Hi,

I have a (detail)form which has a parameterized query as its recordsource. This form should be opened when clicking a button on the mainform. The value of the parameter should be the ID of the current record on the mainform.


How can I fill the parameter with the correct value and then open the detailform?

Thanks in advance,
Nils

[NoellaG]

Hi,

I presume the [ID] field makes part of your query. So just put as the selection criterium on this ID field:

Forms![Name form]![Name ID field on the form]

[ngruson]

What I have now is the following:

Public Sub OpenForm(frm As String, Optional qry As String)
    Subform.SourceObject = frm
    If qry <> "" Then
        Subform.Form.RecordSource = qry
    End If
    Subform.Visible = True
End Sub

This code is called in the main form. When a button in the mainform is clicked, the subform control is bound. When a detail form needs to be shown, the qry parameter is set with the right query to show one record (select * from tasks where id = 1).
Is this optimal? Now I rebuild the query everytime. Isn't there a way to bound a form to a parameterized query in designtime and set the parameter of this query in runtime?

[NoellaG]

Hi,

if the relations are put right you can bind your subform to the main form using the Primary and Foreign key fields in the "Link Master fields" and "Link child fields" property of your subform control. When the relations are OK, Access wxill even propose these fields as binding fields by default.

greetings
NG