You can have "min." in a label. Or concatenate the string.
Why does expanding address Subdatasheet provoke an input popup? I've never seen this at table level.
Each student can have multiple addresses?
Having an unbound textbox display the TempVars value when the form opens is meaningless. Textbox should be bound to field. Can set it Locked Yes and TabStop No. Not seeing any need for the TempVars.
If you want form to open filtered to specific studentID then apply criteria to the OpenForm WHERE CONDITION argument. Concatenate reference to the textbox. Consider:
Code:
Private Sub btnstudentlogin_Click()
Me.lblvalidID.Visible = False
If Not IsNull(DLookup("[studentid]", "[tblStudentsBio]", "studentid = '" & Me.txtstudentloginid & "'")) Then
DoCmd.Minimize
DoCmd.OpenForm "frmClockIn", , , "studentid='" & Me.txtstudentloginid & "'"
DoCmd.Close acForm, "frmStudentLogin"
Else
Me.lblvalidID.Visible = True
Me.txtstudentloginid.SetFocus
End If
End Sub
Saving calculated data requires code in some event. The real trick is figuring out what event. Otherwise, just run the calc when the data is needed.
Is 4. resolved?
Don't really understand what you want for 5.
Write code as appropriate for the buttons in 6.