refreshing query data with calendar control

[seth]

i think the subject says it all
i'm trying to see if it's possible to refresh query data with calendar
control

i have a form based on a query that can ask for a specific date, or all
records from today
what i want to do is insert the calendar control (done that) select a date
(done that) and have the entire query refresh with that date (haven't quite
done that)

i have the control associated with the date field
so, for example, if the query pulls all records from december 28 and on the
calendar control, if i select december 10 i want all the records to show
only december 10 as i scroll through the records on the form.

the furthest i got was selecting a different date and showing the current
record from that date; scrolling around still shows date from query

is this possible?
have i explained it enough??

tia

 

[Guest]

it can only be done by creating a vba function.
however, if you don't want to write code
I suggest creating a separate form for your calendar and call it from your
main form (the one displaying data) with a button - (and maybe add another
button to run/refresh the data)

 

[seth]

ok...i've gotten that far
it's the vba part i need help with
i could select a date on the calendar and open a form based off a query with
that selected date; not sure how to do the code