Form Parameter for Query

[daralick]

I have a form with two subforms.

The main form holds the Order Number and basic information.

The 1st subform holds an abbreviated list of products in the order and the data source is a table that uses master and child fields to populate.

The 2nd subform holds product details and I am attempting to use a query with one parameter to populate details. On the form load the product detail should be the first product in the 1st subform.

What is the preferred method to populate the query parameter. And will that method work with the initial form load and when an event is fired when a user clicks on a product in the 1st subform.

all assistance appreciated
thanks
daryl

[wlc04]

I'm having a hard time "seeing" your db in my head.

You only mentioned one table - are you using the same table to populate all forms?

Can you give me a little more detail about your table structure then I might be able to help.

:confused:

[cweiss]

You can set a reference to a form's underlying recordset and return the current value like this:

Private Function ParamValue() as String
 
    'Assumes your first subform is named Table2_Subform
    Dim rs As DAO.Recordset
    Set rs = Form_Table2_Subform.Recordset
 
    ParamValue = .Fields("ProductID").Value
 
End Sub

Here, ParamValue will always return the value of the ProductID field for the selected record.

You'll probably need to add some error handling for empty recordsets, but otherwise I think you should be able to modify this code to suit what you're trying to do.