Subform/Query Help...

[Rjc8513]

Thanks for the previous post, Sawatzky. Couldn't seem to grasp that. Took your suggestions to post with a clearer subject. Other ideas?

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...

 

[BoxHead]

Use the beginning date combo box and the ending date combo box as criteria in your query for the BegDate and EndDate fields. Run qry_Archive.Requery on the before update events of each combo box.

HTH


John