From: cutepaloma405 via on
I have two forms: frmFaculty and frmCourse. I have linked these two forms
through the FacultyID. When I open the frmCourse through the frmFaculty it
transfers the FacultyID because I given frmCourse OnCurrent the following

If Me.NewRecord Then
[FacultyID].DefaultValue = Forms![Faculty]![FacultyID]
End If

My problem is that if the FacultyID is 094511 for some reason it does not
pick up the zero. This is odd because I made this field into a string.

Can someone help me in explaining how do I make the zero appear in the front
when I open the frmCourse?
Thank you!!

Message posted via