E
etter34
Hello,
I've tried searching for this, but have not had any luck. I'm
relatively new to Access, and this is just getting away from me. Any
help would be greatly appreciated..
I've got a form set up that has a calendar and a combobox that is
populated upon clicking a date in the calendar. What I've tried to set
up is a subform below the calendar that uses the date from the combobox
above it to find all records (in the query) with that particular date
and display pertinent info.
I can get it to work, but it does not update dynamically. For
instance, if I click on 5/5/2006 it pops into the combobox, but the
subform query won't show up until I go into form design, and then back
to form view. How does one go about having the subform query update
automatically when the combobox is changed?
Thanks!
My form name is frmdateqry, and subform is frmdateqrysubform (kinda
confusing I know) - and combo box name is cbodatein.
I've tried searching for this, but have not had any luck. I'm
relatively new to Access, and this is just getting away from me. Any
help would be greatly appreciated..
I've got a form set up that has a calendar and a combobox that is
populated upon clicking a date in the calendar. What I've tried to set
up is a subform below the calendar that uses the date from the combobox
above it to find all records (in the query) with that particular date
and display pertinent info.
I can get it to work, but it does not update dynamically. For
instance, if I click on 5/5/2006 it pops into the combobox, but the
subform query won't show up until I go into form design, and then back
to form view. How does one go about having the subform query update
automatically when the combobox is changed?
Thanks!
My form name is frmdateqry, and subform is frmdateqrysubform (kinda
confusing I know) - and combo box name is cbodatein.