Pulling Record Info From Sub Form

[redlich23]

I was wondering if someone could help me with an issue. I have a form that contains a sub form. The sub form is a list of records that meets a time interval + or minus a specific time (Designated by the user prior to opening the main form). I also have two fileds called Min Price and Max Price on the main form. These fields pull the lowest & highest values from a field called price of the record set from the sub form.

What I need to do is also pull the values from a field called time for the Min and Max price records calculated above.

any ideas?

[Ryan]

I believe, you can use combo boxes. In the Query, tell it to use the criteria from the combo box's max and min.

https://www.accessforums.net/queries...form-2800.html

Rural told me how to make the subform, you may have to change it to datasheet. And the criteria (combobox's) has to be added to the query.
The criteria in the query should look something like this

[Forms]![Your Document Name here]![combo1]

The combo box would be your min and max, you would need two.