Help with VBA please - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Help with VBA please

Robert Freeman

2 years ago

Hello. I have a membership database that runs fine but I've just come across a problem with some vba code I'd appreciate help with.
The code is currently:

Details

Private Sub Form_BeforeUpdate(Cancel As Integer)
DoCmd.SetWarnings False
DoCmd.RunSQL "INSERT INTO MemberDetailsChangeLogT   SELECT * FROM MemberDetailsT " & _
"WHERE Member_ID=" & Member_ID
DoCmd.SetWarnings True
End Sub

This runs fine when there is a record already in the database to reference but when I input a NEW member record it throws up a vba error. I'm assuming this is because there is no existing record to reference. I believe I need to add an 'IF' / 'THEN' element to the vba but I'm not sure how/where it should fit into the existing vba code.

I appreciate it if someone would help me out with the additional code please.
Thanks.

	Kevin Robertson @Reply 2 years ago
Try this: `If Not Me.NewRecord Then ' Your code here End If`

	Robert Freeman OP @Reply 2 years ago
Thanks Kevin - again! That worked perfectly. It threw up another issue when it worked but I've sorted that one myself.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View