I have eight tables, all but two of which must be connected by the ID# (in this case called "TrackingNo") by "qryEmergent." On the Input Form, I have been asked to do two things with the entries that I have no idea how to accomplish.
1) Timeout if keys idle for 10 minutes and remove all fields in current entry, including the Tracking No.
2) On click of close button, cancel event, if required fields:
"Requestor,"
"WorkDescription,"
["WO" (for work order #) and "WR" (for work request #)
and "PMRQ" for Preventive maintenance required #],
"MarkNo"
"System", or
"Justification"
is null and return focus key to each field requiring entry, in order. If close is forced without required fields, remove all fields, including tracking no.
PS: Is autonum required if the field is the index key?
Thanks
Imjay
1) Timeout if keys idle for 10 minutes and remove all fields in current entry, including the Tracking No.
2) On click of close button, cancel event, if required fields:
"Requestor,"
"WorkDescription,"
["WO" (for work order #) and "WR" (for work request #)
and "PMRQ" for Preventive maintenance required #],
"MarkNo"
"System", or
"Justification"
is null and return focus key to each field requiring entry, in order. If close is forced without required fields, remove all fields, including tracking no.
PS: Is autonum required if the field is the index key?
Thanks
Imjay
