validation rule error

[Jason]

I have changed a unbound field on a form to a field in a table. Now I get:

Run-time error '2115'
The macro or function set in BeforeUpdate or ValidateRule Property for this
field is preventing access from saving the data in the field.

The field type is single and the value entered is 30. Which is correct in
the sense it is valid for this field type.

Thanks,
J.

 

[Douglas J. Steele]

Do you have code in the BeforeUpdate event for the control? If so, what is
it?

Do you have a ValidationRule set for the field? If so, what is it?

 

[Jason]

there is no code for beforeupdate and there is no validation rule (already
had checked these two).

 

[Douglas J. Steele]

What about in the form's BeforeUpdate event (as opposed to the control's
BeforeUpdate event)

If not, then I'm afraid I have no idea.

 

[Jason]

I over-wrote the mdb file with an older one (undone the changes and started
again). What I have done is in the forms recordset added
Fieldname2:Fieldname then used code on the form to update fieldname2 instead
of fieldname. This appears to be working.