command button- add new record

[Fredgarner]

On my switcboard I have a command button that allows the user to enter a new transaction on the 'Transactions (by contact)' form. The code reads thus:

Private Sub Command13_Click()
On Error GoTo Err_Command13_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Transactions (by Contact)"
DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd

Exit_Command13_Click:
Exit Sub

Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click

End Sub

There is only one problem- on the original 'Transactions (by Contact)' Form, there are 2 drop-down list boxes that allow the user to navigate to a specific contact, and then enther a transaction for that contact. However, when my 'add new record' command button is used, the drop-down list boxes, whilst coming up with the correct name in the box when I enter the first few letters, does not navigate to that record when I press 'Return'. In other words,the version of the from being openened by the command button is an incomplete versionof the one I created! If I am being unclear, I would be happy to clarify, because this is a total mystery to me and I would love some help!

 

[lupins46]

If you are adding a new record there should be no record there for the combos to navigate to.
Please clarify what you are trying to do here.