I see 2 options of solving this problem and maintaining that numeric field:
1. Change the numeric value to text in the process with the str() function; or 2. Convert the process into numeric process with the val() function. At least that solved my problem. Hope yours too. Djeme ________________________________ From: Michael Van Der Stad <[email protected]> To: [email protected] Sent: Thursday, April 9, 2009 9:54:15 PM Subject: [ms_access] linking form to subform The value you entered isn't valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits. Now, there is no FieldSize setting, and I've not told it to be numeric. Changing the values queried from numeric to text (by changing the Field Data Type in the Table the values are pulled from) causes this to work fine, but I need the numeric field to STAY numeric. Is this one of those bugs caused by using MS Access 2003 SP3 that the 'office2003- kb945674- glb.exe' will fix? If not, can anyone see a way to fix this? Does anyone know how to fix this? Techtypes.com Regards, Michael Van Der Stad [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
