I'm using the onopen event of a form to determine if a second form should open right to a record.
Here is my code which isn't anywhere near right I'm sure. Can someone help?
Private Sub Form_Open(Cancel As Integer)
Dim recordcount As Integer
If recordcount = 1 Then
DoCmd.OpenForm "frmIndividuals", acNormal, , "[IndividualID]=" & Me.txtIndividualID, acFormEdit, acWindowNormal