Prev: Access 2007 - Recordsource & Subform
Next: Error 3075 Syntax Error
From: cutepaloma405 via AccessMonster.com on 25 Feb 2010 14:39
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
language:

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 AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1

 | 
Pages: 1
Prev: Access 2007 - Recordsource & Subform
Next: Error 3075 Syntax Error