OK, Need Help!

[Rjc8513]

Just when I finish patting myself on the back over my latest accomplishment, Access brings me to my knees once again!

I have a main form [frm ARCHIVE] whose record source is the query [qry ARCHIVE]. The combo box [cbxUNIT] on the main form is used for the query's criteria in the [UNIT] field. When I select the desired Unit Name in the combo box, the correct data is displayed in the subform [sfm ARCHIVE] on the main form (the subform's record source is also [qry ARCHIVE]). This part works just fine.

But, now I want to take the selected unit's data and, using the combo boxes [BegDate] and [EndDate], filter the data displayed in the subform so that only the range of dates selected in the combo boxes is displayed. I can't get this part to work right.

What am I doing wrong? Thanks.

Richard...

 

[Sawatzky]

dear rjc8513,

the form itself has a filter property that could be set to: [datefile]>[begdate] and [datefield]<[enddate]
the query has a filter property too.
I am not sure which of them is apropriate for you, so just give it a try


regards astrid

btw:
the title of this thread does not show your problem. It is easier for people to see if they can help or not, if they know what the thread is about. this could be for your problem: Form or query filter problem