theinviter
Registered User.
- Local time
- Today, 04:39
- Joined
- Aug 14, 2014
- Messages
- 237
Dear all;
I have a form that upon double click on list open another form and filter it,
i tried below code but not working
DoCmd.OpenForm "MRN_Query1_Delivered", acNormal, , "[Item Code] = '" & Me.List6 & "' and [Location - Clinics Code] = MRN_Query1_subform.[Location_Code] & "
item code is text
and location code is number
can you please advise me
I have a form that upon double click on list open another form and filter it,
i tried below code but not working
DoCmd.OpenForm "MRN_Query1_Delivered", acNormal, , "[Item Code] = '" & Me.List6 & "' and [Location - Clinics Code] = MRN_Query1_subform.[Location_Code] & "
item code is text
and location code is number
can you please advise me