Filtering with combo box

[PoorBoy]

hi im new, i have a table1 with name and gender. i want to use combo box with male/female to filter. then display to a listbox that display table1
when click male in combo box will only show male with name at the listbox
when click female in combo box will only show female with name at the listbox

[Bob Fitz]

Take a look at Form1 in the attched db.
BTY, "Name" is a reserved word in access so it should not be used as the name of any object. See: http://support.microsoft.com/kb/286335
FName, FirstName, LName, LastName, would be better.

[Siiig]

Hey Bob,

I was looking at the DB you put together here. I tried to re-create it from scratch, just for practice, but got caught up on your OnRefresh.

What does that VB code to?

[PoorBoy]

it works thx , i want to add "both" in the gender and 1 more field into the table "Available At" with morning/afternoon/night same thing with gender for filter.

[Bob Fitz]

Hey Bob,

I was looking at the DB you put together here. I tried to re-create it from scratch, just for practice, but got caught up on your OnRefresh.

What does that VB code to?

OnRefresh . Perhaps you mean:

Private Sub cmbGender_AfterUpdate()
  Me.lstFNames.Requery
End Sub

This requeries the combo box which has criteria set in the SELECT statement of its Row Source property that restricts the data in the list box to records that have the same gender as that which is selected in the combo box

[Siiig]

OnRefresh . Perhaps you mean:

Private Sub cmbGender_AfterUpdate()
  Me.lstFNames.Requery
End Sub

This requeries the combo box which has criteria set in the SELECT statement of its Row Source property that restricts the data in the list box to records that have the same gender as that which is selected in the combo box

Yup, you got it right Bob. After I read your VB code (I'm not sure what the proper name for this is) I understand what it's aiming to do, but after replicating it I'm still not getting desirable results.

Any chance you might take a peek at my attempt to recreate? Maybe you can find something that's obviously wrong.

The test data was actually based on another thread. These two seemed to go well together.

[Bob Fitz]

siiig

I have made a couple of changes

[Siiig]

Hey Bob, I just ran through the settings in there, and I can't seem to locate what you changed

[Bob Fitz]

I removed the first column of the combo box by changing the Row Source property. Also changed the Column Count and Column Widths properties of the combo