Hi all,
I have a access 2000 database with linked tables to a access 2000 backend
database. The performance is really slow. I am looking for the best way
to open a form to add a new record without retrieving the full dataset.
In my sample below I have two options I could think of, is there any
important difference? Which one is better or quicker to use? Am I on the
right track?
Thanks and sorry for being a newbie.
Newbie.
Private Sub cmdObservationRecords_Click()
On Error GoTo Err_cmdObservationRecords_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmObservation"
DoCmd.OpenForm stDocName, , , stLinkCriteria
' -- Option 1 --
Forms!frmObservation.DataEntry = True
' -- Option 2 --
' DoCmd.GoToRecord acDataForm, stDocName, acNewRec
Exit_cmdObservationRecords_Click:
Exit Sub
Err_cmdObservationRecords_Click:
MsgBox Err.Description
Resume Exit_cmdObservationRecords_Click
End Sub