Error 3331 & validation rule error

  • Thread starter Thread starter tope12
  • Start date Start date
T

tope12

I made this data entry from that uses the .addnew method to add records to a
query recordsource. When i enter a value into a text box, i run a parameter
query by code to fill in another textbox on the form. when i execute the
addnew method,it saves the record. when i enter a value into my textbox to
run the parameter query for the new record. I get Error 3331 "to make changes
to this field,first save the record". I tried to add a DoCmd.RunCommand
acSaveRecord after .update in the addnew method,but it didn't work. Are
there any to get around that error? I also get a validation rule error when
i try to change the recordsource after i add a couple of records.
 
tope12 said:
I made this data entry from that uses the .addnew method to add records to
a
query recordsource. When i enter a value into a text box, i run a
parameter
query by code to fill in another textbox on the form. when i execute the
addnew method,it saves the record. when i enter a value into my textbox to
run the parameter query for the new record. I get Error 3331 "to make
changes
to this field,first save the record". I tried to add a DoCmd.RunCommand
acSaveRecord after .update in the addnew method,but it didn't work. Are
there any to get around that error? I also get a validation rule error
when
i try to change the recordsource after i add a couple of records.
Click to expand...
 
Back
Top