I am using two list boxes.
On click in listbox1 value the data is shown in listbox2 as per the selection in listbox1.
on double click in listbox2, as per the selection the specific record should have to open.
It's working on received transactions and opening the exact record what is required for.
But for "Transferred" transactions it's opening with blank record with the same head as "Receipt" as shown in the attachment.
what's the reason.
On click in listbox1 value the data is shown in listbox2 as per the selection in listbox1.
on double click in listbox2, as per the selection the specific record should have to open.
Code:
Private Sub DynamicList1_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmTransactionsMain", , , "[TransactionsPK]=" & Me![DynamicList1]
End Sub
It's working on received transactions and opening the exact record what is required for.
But for "Transferred" transactions it's opening with blank record with the same head as "Receipt" as shown in the attachment.
what's the reason.