D
Denver
I have Form with a subform and combobox..
i have this rowsource for my combo58
RowSource:SELECT DISTINCT location FROM [Data Entry2] UNION SELECT ' All
Locations' FROM [Data Entry2] ORDER BY location;
i set Link childs and Link Master fields to blank.. so that all my records
will be displayed in my subform.
can anyone help me how can i write my codes for my Combo58 that when i
select a certain location it apply filters and when I select "All locations'
it will display back again all my records in the subform?
thank you and more power
i have this rowsource for my combo58
RowSource:SELECT DISTINCT location FROM [Data Entry2] UNION SELECT ' All
Locations' FROM [Data Entry2] ORDER BY location;
i set Link childs and Link Master fields to blank.. so that all my records
will be displayed in my subform.
can anyone help me how can i write my codes for my Combo58 that when i
select a certain location it apply filters and when I select "All locations'
it will display back again all my records in the subform?
thank you and more power