Basic VBA

[satty]

hey people!

im currently havin a problem with VBA. i have a form from where the user can Add or Amend Customers. I have the following code to the Add button:

Private Sub AddNewCustomer_Click()
On Error GoTo Err_AddNewCustomer_Click

Dim stDocName As String
Dim stLinkCriteria As String

DoCmd.Close
stDocName = "Customer Details"
DoCmd.OpenForm stDocName, , , stLinkCriteria


Exit_AddNewCustomer_Click:
Exit Sub

Err_AddNewCustomer_Click:
MsgBox Err.Description
Resume Exit_AddNewCustomer_Click

End Sub

Howeve, i want the form to be in 'ADD MODE' when i click this button. how would i go about doing this? or is there an easier way?

Thanx Guys!


SaTTy

 

[SydneyGeek]

I don't have Access in front of me so can't give the exact syntax, but this line...

DoCmd.OpenForm stDocName, , , stLinkCriteria

...will accept the mode argument. In the module, retype that line and follow the prompts -- after one of the commas you will see drop-down options for acAdd, acEdit, and acReadOnly (or similar).

Denis