steadyonabix
New member
- Local time
- Today, 05:18
- Joined
- Mar 11, 2009
- Messages
- 5
Hi
I am having a strange problem I have not come across before.
I am putting a database together and for the first time I am not using bound controls but writing specific functions to query the backend SQL server database and update the MS Access front end controls.
These functions work well and the controls are populated with the data when the form loads. Now I am writing functions to change the data displayed in some controls when the user clicks on a list of file names in a listbox. However when I try to update a text box with new text for a second time I get the error: -
"The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field."
The validation rule is blank and the BeforeUpdate function does not exist so I cannot understand why it is giving me this error or why it is trying to save anything as no record source is defined for the control, (or any control).
Just creating the simple sub: -
Private Sub lstFileList_Click()
On Error GoTo zz
txtReviewComments.SetFocus
txtReviewComments.Text = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
zz:
MsgBox "Error in function SizeRequestingTeamArray - " & Err.DESCRIPTION
End Sub
gives this error.
Anyone have any ideas as to what the problem is?
Thanks
Bradley
I am having a strange problem I have not come across before.
I am putting a database together and for the first time I am not using bound controls but writing specific functions to query the backend SQL server database and update the MS Access front end controls.
These functions work well and the controls are populated with the data when the form loads. Now I am writing functions to change the data displayed in some controls when the user clicks on a list of file names in a listbox. However when I try to update a text box with new text for a second time I get the error: -
"The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing Microsoft Office Access from saving the data in the field."
The validation rule is blank and the BeforeUpdate function does not exist so I cannot understand why it is giving me this error or why it is trying to save anything as no record source is defined for the control, (or any control).
Just creating the simple sub: -
Private Sub lstFileList_Click()
On Error GoTo zz
txtReviewComments.SetFocus
txtReviewComments.Text = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
zz:
MsgBox "Error in function SizeRequestingTeamArray - " & Err.DESCRIPTION
End Sub
gives this error.
Anyone have any ideas as to what the problem is?
Thanks
Bradley