N
nm
I have a continuous form containing summary information
that is pulled from 3 different tables, ex:.
tblConfig tblTest tblRework
ProductID(pk) ProductID(pk) ProductID(pk)
EquipID FinalThkness EquipID
InletTemp Resistivity Ramp1Temp
OutletTemp Ramp1Dwell
Zone1Temp
Zone2Temp
Rework
etc......
From this form I would like to add a command button that
will open another form that contains all the data for the
selected ProductID. The catch is that depending on the
EquipID there will be a different form to call because for
example some equipment collect Inlet/Outlet Temps others
have Zone temps. Also not all Products will have data in
tblRework only those where Rework=Yes so on that part of
the form I'm calling, I would like to display, "No reworks
performed on this product" instead of the controls. I
don't know how to specify the criteria beginning with the
selected record in the continuous form. Any pointers on
how I can get this accomplished?
that is pulled from 3 different tables, ex:.
tblConfig tblTest tblRework
ProductID(pk) ProductID(pk) ProductID(pk)
EquipID FinalThkness EquipID
InletTemp Resistivity Ramp1Temp
OutletTemp Ramp1Dwell
Zone1Temp
Zone2Temp
Rework
etc......
From this form I would like to add a command button that
will open another form that contains all the data for the
selected ProductID. The catch is that depending on the
EquipID there will be a different form to call because for
example some equipment collect Inlet/Outlet Temps others
have Zone temps. Also not all Products will have data in
tblRework only those where Rework=Yes so on that part of
the form I'm calling, I would like to display, "No reworks
performed on this product" instead of the controls. I
don't know how to specify the criteria beginning with the
selected record in the continuous form. Any pointers on
how I can get this accomplished?