Hi everybody
I have a database created in access 2007. In one form I created a button with the following VBA code (on click event)
DoCmd.GoToRecor d , , acNewRec
A_S = Nz(DMax(“A_S”, “Table1”)) + 1
Because it’s a multiuser form I want every time someone clicks that button, to refresh the form, show any new records (if there are) that have been created from other users, and create a new record to write.
I used the following code
Me.Requery
Me.Refresh
DoCmd.GoToRecor d , , acNewRec
A_S = Nz(DMax(“A_S”, “Table1”)) + 1
With the above code when I click the button I get the 2105 error on the 3rd line.
I have a database created in access 2007. In one form I created a button with the following VBA code (on click event)
DoCmd.GoToRecor d , , acNewRec
A_S = Nz(DMax(“A_S”, “Table1”)) + 1
Because it’s a multiuser form I want every time someone clicks that button, to refresh the form, show any new records (if there are) that have been created from other users, and create a new record to write.
I used the following code
Me.Requery
Me.Refresh
DoCmd.GoToRecor d , , acNewRec
A_S = Nz(DMax(“A_S”, “Table1”)) + 1
With the above code when I click the button I get the 2105 error on the 3rd line.