To answer your question, somebody already asked about records and #Error messages.http://www.utteraccess.com/forums/showflat...1409616&Zp=
Now, if somebody could help me with the #Error messages I get in forms? Whenever I go make a new record, I have the following control text for a field:
This is a simple function. DesignPres is defined as a double in the table, and here is the returnPres function:
Public Function returnPres(ByVal num As Double) As String
If num > -14.7 Then
returnPres = CStr(num) & " PSIG"
returnPres = "--"
The function works fine whenever I already have a record for [DesignPres]. I have all sorts of functions throughout all my forms, and I get annoyed whenever I see a "#Error" message when I go make a new record with my forms. The user enters [DesignPres] in another form, and I have it display in several other forms as a reference. Help?