B
Brook
good day all,
I have a frmchecking acct that has ID, DATE, Description, Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction notes.
I created a button to open the form to the current record based on ID, and
for a test I put the field ID visible on the pop up form (frmdetails), but
when the form opens from the current record, the ID Still shows (autonumber)
and doesn't "go to" the current record details?
Here is my code:
Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmcheckingAdd/Edit"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command28_Click:
Exit Sub
Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click
End Sub
Any suggestions?
Thanks,
Brook
I have a frmchecking acct that has ID, DATE, Description, Debit, CRedit,
and the pop up form has Acct Type, Reference, transaction notes.
I created a button to open the form to the current record based on ID, and
for a test I put the field ID visible on the pop up form (frmdetails), but
when the form opens from the current record, the ID Still shows (autonumber)
and doesn't "go to" the current record details?
Here is my code:
Private Sub Command28_Click()
On Error GoTo Err_Command28_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmcheckingAdd/Edit"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command28_Click:
Exit Sub
Err_Command28_Click:
MsgBox Err.Description
Resume Exit_Command28_Click
End Sub
Any suggestions?
Thanks,
Brook