S
Seth Schwarm
Access XP
I have created a form I use to build a where clause which eventually filters
a report. This form has a list box whose row source is based on a query
referencing begin and end dates on the same form the list box is located on.
I update the list box by using code me!listbox.requery on the after update
event of the two date fields.
I have data in the database between 4/1/05 and 5/31/05.
The problem:
As long as I enter date criteria between these dates the list box requeries
great. But when I enter date criteria of say 1/1/05 and 12/31/05, the list
box doesn't appear to requery.
I have fiddled with dates of all varieties. For example if I enter 1/1/05
and 11/15/05 the list box requeries, but if I enter a date which is the last
day of the month, the list box does not requery.
I thought maybe there was some type of a disconnect between my form and
query (row source for list box). I tested my queries in the query
environment and they worked flawlessly no matter what date criteria I fed
them.
I am confused and frustrated as I have never had this experience in my years
of building databases.
Thanks,
Seth
I have created a form I use to build a where clause which eventually filters
a report. This form has a list box whose row source is based on a query
referencing begin and end dates on the same form the list box is located on.
I update the list box by using code me!listbox.requery on the after update
event of the two date fields.
I have data in the database between 4/1/05 and 5/31/05.
The problem:
As long as I enter date criteria between these dates the list box requeries
great. But when I enter date criteria of say 1/1/05 and 12/31/05, the list
box doesn't appear to requery.
I have fiddled with dates of all varieties. For example if I enter 1/1/05
and 11/15/05 the list box requeries, but if I enter a date which is the last
day of the month, the list box does not requery.
I thought maybe there was some type of a disconnect between my form and
query (row source for list box). I tested my queries in the query
environment and they worked flawlessly no matter what date criteria I fed
them.
I am confused and frustrated as I have never had this experience in my years
of building databases.
Thanks,
Seth