J
jackle
Can/how can one use a combo box in a form to control the
input to an SQL which controls the subdatasheet?
Currently I have >[Start Date] And <[End Date] in the
SCHED_COMP_DATE field in the select query data display.
This selects the start date and end date of a search. I
can run the query, but I want to do a form/subdatasheet
layout so anyone can enter in any dates in the form and
run the query and see the results in that subdatasheet.
I'd prefer this to doing a filter on a table, because I
would have to link to a table that has, maybe, 100,000
records and all you need is a couple of hundered (or is
this really the way to go?).Can you point me in the right
direction. Thanks in advance.
input to an SQL which controls the subdatasheet?
Currently I have >[Start Date] And <[End Date] in the
SCHED_COMP_DATE field in the select query data display.
This selects the start date and end date of a search. I
can run the query, but I want to do a form/subdatasheet
layout so anyone can enter in any dates in the form and
run the query and see the results in that subdatasheet.
I'd prefer this to doing a filter on a table, because I
would have to link to a table that has, maybe, 100,000
records and all you need is a couple of hundered (or is
this really the way to go?).Can you point me in the right
direction. Thanks in advance.