A
alpapak via AccessMonster.com
Code problem!!!
------------------------------------------------------------------------------
--
hi
i have a form [Customers] (continiousform) and when i doubleclick the surname
of a customer, the form [Details] (single form) open
until here everything is ok
the problem is that the code i use open [Details] and use [SurnameID] as a
filter
i want to be able to open [Details] and see all records, but to focus on my
[SurnameID]
Private Sub Surname_DblClick(Cancel As Integer)
DoCmd.OpenForm "Details", , , "[SurnameID] = " & Me.SurnameID
DoCmd.Close acForm, "Customers", acSaveNo
End Sub
thxs
------------------------------------------------------------------------------
--
hi
i have a form [Customers] (continiousform) and when i doubleclick the surname
of a customer, the form [Details] (single form) open
until here everything is ok
the problem is that the code i use open [Details] and use [SurnameID] as a
filter
i want to be able to open [Details] and see all records, but to focus on my
[SurnameID]
Private Sub Surname_DblClick(Cancel As Integer)
DoCmd.OpenForm "Details", , , "[SurnameID] = " & Me.SurnameID
DoCmd.Close acForm, "Customers", acSaveNo
End Sub
thxs