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