Combo Boxes to Filter n Show Tables

[Spoony]

Im kinda new to Access and only been using the "Access 2003 for Dummies" for learning and making small databases. So far I can find out how to do the things I want, but recently got stuck with a combo box feature. What im trying to do is select entries in my combo box so that it will filter the table and show all its contents based on that filter. Im not sure how to link the combo boxes the right way and it seems some VB coding is needed which I dont normally use. If anyone has any idea how to do it, tell me how! Thanks. BTW im using Access 97.

 

[Spoony]

maybe i didn't explain clearly but i think its a common n simple process which im just not familiar. I just want to open a table based on wat i select in the combo box.

eg.
*Table:
Age Name
12 John
13 Micheal
12 Steve
11 Bob

*Combo Box entries (Age):
11
12
13

If I select 12 in my combo box, it should filter and open the table containing:

Age Name
12 John
12 Steve


Anyone knows how its done? thx

 

[WIS]

maybe i didn't explain clearly but i think its a common n simple process which im just not familiar. I just want to open a table based on wat i select in the combo box.

eg.
*Table:
Age Name
12 John
13 Micheal
12 Steve
11 Bob

*Combo Box entries (Age):
11
12
13

If I select 12 in my combo box, it should filter and open the table containing:

Age Name
12 John
12 Steve


Anyone knows how its done? thx

Easier to do a small database than explain. It has 1 table, 2 queries and 1 form. Run the form to see if it is the result you want.

There are several things that need to be done - the only item that isn't reqd was the form's On Open event -> DoCmd.Maximize (to make the form fill the whole screen).

 

[WIS]

Sorry Spoony, I sent you the Ak2 version - here is the A97 one.

 

[Spoony]

ok thx, I think this is wat i need. Trying to figure out how to put in my table now.

 

[Spoony]

I can't seem to get the event to work, dono why. I have done exactly the same procedure but its not working

I made a query similar to qryGroupofAge and qryName. Put in the event procedure code in Afterupdate, used the same names etc, but when i click on my combo box nothing happens

Is there any other things i need to change?

 

[WIS]

I can't seem to get the event to work, dono why. I have done exactly the same procedure but its not working

I made a query similar to qryGroupofAge and qryName. Put in the event procedure code in Afterupdate, used the same names etc, but when i click on my combo box nothing happens

Is there any other things i need to change?

Check all the properties of your combo box. Do you have the correct RowSource ppty etc. Make sure that the forms reference to the combo box is entered in the Age Criteria of the query.

If all fails why don't you post your database - it should be something easy to fix.

 

[Spoony]

I made several forms and used the similar queries and they work. Its only the main form im trying to use it on doesn't work. There is something on the main form that is preventing this feature but i dono wat it is.

I can't post the database, its over 500 mb and im not allowed to distribute the info . I think the form that im working on is a Switchboard form.