Using drop-downs to select search criteria

[jon98548]

Hey, guys. It's been a while, but guess who needs help again. I use the form in this db to select search criteria for the subform. I have another db that uses a form similar to this with no trouble at all. I got the code from some one here and it works great in the other db, but no matter what I do the form in this report db is ignoring my search criteria. As far as I can tell, I have everything the same. I would appreciate any input as to what I'm missing. I have scaled this version down greatly from the original, but if I can get the one to work I think I can add other search fields as I need them. Thanks.

 

[WayneRyan]

Hi Jon,

I kept the query for the subform constant, but used the combo as the
Criteria. See the query.

Used the AfterUpdate of the combo to Requery and removed the buttons.

Probably better to use a QueryDef, but this works.

Wayne

 

[jon98548]

That's good, but what about when I add other criteria. I stripped this version down for simplicity. The original has 5 different drop-downs to filter. In the long version I have a list of agents, buildings and other info. So I might search for reports on a specific agent in one building.

 

[WayneRyan]

Jon,

OK, have you looked at Search here (and Sample Databases) for "Cascading"
combos? This is a pretty common topic here.

Look at them, and repost a more complete sample. It shouldn't be that
difficult.

hth,
Wayne