Run-Time Error 2115

  • Thread starter Thread starter mieke
  • Start date Start date
M

mieke

Hi,

I want to fill in a field on a from automatically in certain
conditions, but I get the following error when putting the data in it:
Run-Time Error 2115: The Macro or function set to the BeforeUpdate or
ValidationRule property for this field is preventing the database from
saving the data in the field.

I don't get this since there is no BeforeUpdate or ValidationRule
attached to this textbox. it is even not attached to the database.

This is the code I'm using:

Me!Text39.SetFocus
Me!Text39.Text = NewValue

Where NewValue is a string value and is not empty at that moment.

Thanks for your help
 
mieke said:
Hi,

I want to fill in a field on a from automatically in certain
conditions, but I get the following error when putting the data in it:
Run-Time Error 2115: The Macro or function set to the BeforeUpdate or
ValidationRule property for this field is preventing the database from
saving the data in the field.

I don't get this since there is no BeforeUpdate or ValidationRule
attached to this textbox. it is even not attached to the database.

This is the code I'm using:

Me!Text39.SetFocus
Me!Text39.Text = NewValue

Where NewValue is a string value and is not empty at that moment.

Thanks for your help
Click to expand...

You can't set the value of a textbox by using the Text property. Try using
the Value property instead.

Carl Rapson
 
You can't set the value of a textbox by using the Text property. Try using
the Value property instead.

Carl Rapson- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

This works now, thanks.
 
Back
Top