I am setting up a form that uses a button to open another form; this form requires you to input a minimum time and a maximum time (table is one the shows action in time sequence). The form that this button is on uses a query to get the min and max time.

I would like the button to open the form using the min and max times on the form that is open..
the form that is open is named: frmMinMaxTime.
Field names: MinTime

Form that it is opening has and Expression that asked for the values that you are required to input.
TimeRange: Partition([qryMJMsg].Time,[StartTime ],[StopTime],[IntervalSize])

Again what I would like to do is have the button that opens use the frmMinMaxTime.MinTime and frmMinMaxTime.MaxTime to answer the [StartTime] and [StopTime].

The Button code that I use to open the button is as follows:
Private Sub Command8_Click()

Dim stDocName As String
Dim stLinkCriteria As String

' [MinOfUTCs] «Expr» Forms![frmMJMain]![SenderID]

stDocName = "frmMJMain"
DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria

Exit Sub

MsgBox Err.Description
Resume Exit_OpenfrmMJMain_Click

End Sub