Hi,
I am trying to develop a database with multiple tables and too many forms. But with that aside, I get about half-way through the program and I reach this one bound form (with two option frames and one text box, all bound), but when I try to update the data and then move to another form, also bound to the same table, I receive a "Runtime error '3426': Action cancelled by associated object." When I dubug, the program is stopped on the .edit line. I don't seem to receive this anywhere else in the program. I use the same code throughout and it seems to work fine until this point.
The code is fairly modular in that I call an update snipet anytime I leave a form. I don't see this issue anywhere else, well at least up to this point. I don't know if this helps, but this particular form opens up a relational table for the first time.
The code I use to update is as follows:
Private Sub UpdateMe()
With Me.Recordset
.Edit
.Update
End With
End Sub
This is the first event called when I try to leave the form, there are other actions, but I don't hit those until after this update. Also, if I skip this sub completely, then the data is never entered into the table. But, subsequent data is updated in the next several forms bound to the same table. Any ideas on what I am doing wrong here? I am using Access2000. Thank you in advance for taking the time to look at this.
Scot
I am trying to develop a database with multiple tables and too many forms. But with that aside, I get about half-way through the program and I reach this one bound form (with two option frames and one text box, all bound), but when I try to update the data and then move to another form, also bound to the same table, I receive a "Runtime error '3426': Action cancelled by associated object." When I dubug, the program is stopped on the .edit line. I don't seem to receive this anywhere else in the program. I use the same code throughout and it seems to work fine until this point.
The code is fairly modular in that I call an update snipet anytime I leave a form. I don't see this issue anywhere else, well at least up to this point. I don't know if this helps, but this particular form opens up a relational table for the first time.
The code I use to update is as follows:
Private Sub UpdateMe()
With Me.Recordset
.Edit
.Update
End With
End Sub
This is the first event called when I try to leave the form, there are other actions, but I don't hit those until after this update. Also, if I skip this sub completely, then the data is never entered into the table. But, subsequent data is updated in the next several forms bound to the same table. Any ideas on what I am doing wrong here? I am using Access2000. Thank you in advance for taking the time to look at this.
Scot