Search results

Oh crap. As it stands, I have nothing for AfterUpdate. Here's what I have: Purchase Orders Form: 'Private Sub Form_AfterUpdate() 'added 10/13/2020, removed 10/19/2020 'Me.EditedBy.Value = GUserName 'Me.EditDate = Date 'End Sub Private Sub Form_BeforeUpdate(Cancel As Integer) 'added 10/19/2020...

That seemed to fix it! Thank you! Two things. 1) I didn't modify the control value for the AfterUpdate, is that okay? 2) There's Cancel As Integer within parentheses for AfterUpdate as a default. Is that important to leave like that?

Okay. Let me test this out.

Thank you for replying! So let me sure I understand: I should remove the AfterUpdate (and leave it blank) and move it to BeforeUpdate? Then in your post-script, could you clarify?

Here you go. I hope I did that correctly. You can login as Username: Access. Password: 123. Or... Username: Han Solo. Password: Han

Thanks for replying. It's a split database. Would it be all right if I created a copy of the front-end with no data?

Hello! I'm not sure if this is the correct forum to post this, but here it goes: I have a database that uses (mainly) two forms: Work Orders, Purchase Orders. I modified their tables, only to reverse all of them, because in testing some new VBA code (After_Update) that updates a record with the...