Filter with a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi.

Someone please point me to the link where I can learn about filtering a
subform based on a combo box. I am having a hard time with the what to do
part.

Thanks

Joe C

Big Papi for president!!!
 
Manningfan? As in Peyton? You apparently don't know the answer either. Maybe
it was because the question came from New England. Just can't get it out of
your throat? Must be stuck!

Now, do you have an answer for me on how to filter a subform from a combo box?
 
Actually, as I recall the Colts beat the Patsies pretty handily last
year. Look for an 8-8 season at best now that Viniteri is a Colt.

Do you not know how to use the Requery event?
 
Actually the Colts didn't play the Pats in the playoffs. Honestly, would you
trade E. James for Adam Vinatieri? It is just as likely that the Colts will
go .500 as the Pats.

I do have an understanding of the Requery event. I just can't figure out the
basic concept of filtering with a combo box. Do you need seperate tables? Can
you use a Combo to filter on the same form? Similiar to the filter by
selection. I don't have an understanding of the concept.

JC
 
Here's the concept, and I hope you understand it better than you do
Football.

In the AfterUpdate (or OnChange, I think both would work) event of the
combo box, you requery the subform. You would put something along the
lines of :

strSql = " SELECT * FROM YourTable WHERE FilterField = '" &
cboYourCombo & "'"

Me.YourSubform.Form.RecordSource = strSql

Me.YourSubform.Requery

This may require some tweaking, but it should get you into Yankee
Stadium (which is where you want to be anyway).
 
OK,

All I need to know about Manning is how many rings does Brady and he have?
As for baseball, I was in Yankee stadium one time with a Padres hat on and I
was still assaulted. (The Padres hat was the son's little league team)
Although, I did have a "Yankees suck" shirt on. That may have played a part.

I'll try this code in the morning.

FYI, you take a kicker over a running back like James and "I" don't know
football?? 3 rings, 2004!!!
 
Back
Top