Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2009-03-31 : 07:10:33
|
| Hi Guys, I am getting run time error 2115 (see error text below). The error only occurs when I change the value of Me!SalesType. Deubg highlights the line that is bolded below, the field is text, and allows zero length. All suggestions are welcomed. Private Sub SalesType_AfterUpdate() hSalesType = Me!SalesTypeEnd SubPrivate Sub SalesType_BeforeUpdate(Cancel As Integer)If Not IsNull(hSalesType) And hSalesType <> "" Then Me!SalesType.Value = hSalesTypeEnd IfHere is the text associated with the error:The Macro of function set to the BeforeUpdate or ValidationRule property for this field is preventing MS Access from saving the date in the field. Thank you,Trudye |
|
|
|
|
|
Run time Error 2115