On Sep 25, 4:39*pm, Salad <o...@vinegar.comwrote:
BEETHOVEN wrote:
I have an option group called Issue_Type on my main form
F1_Member_Demographics_Main. When I select one of the 3 options on the
main form from the option group Issue_Type I want to limit the sub
form F2_Member_Issues records based on the combo box Issue_Code_T1.
Option Group Issue_Type on main form:
1=Complaint
2=Grievance
3=Appeal
Combo Box on sub form:
1=Complaint
2=Grievance
3=Appeal
So if I select Complaint from the option group on the main form I only
want to see Complaints on the sub form etc.
Thanks in Advance
Gary
Forms!MainFormName!SubFormName.Form.Filter = _
* * * * "Issue_Type = " & Me.Issue_Type
Forms!MainFormName!SubFormName.Form.Filter = True- Hide quoted text -
- Show quoted text -
Hello Salad
Below are the 2 options I tried:
Forms!F1_Member_Demographics_Main!F2_Member_Issues .Form.Filter =
"Issue_Type = " & Me.Issue_Type
Forms!F1_Member_Demographics_Main!F2_Member_Issues .Form.Filter = True
or
Forms!F1_Member_Demographics_Main!F2_Member_Issues .Form.Filter =
"Issue_Code_T1 = " & Me.Issue_Type
Forms!F1_Member_Demographics_Main!F2_Member_Issues .Form.Filter = True
Neither one does anything to the form. It still shows all records. The
option group (Issue_Type) data is not stored in any table but the
combo box (Issue_Code_T1) data is. Can you see what I am doing wrong?
Thanks
Gary