combo box query

[Raza]

I have a form containing all the books in a bookstore what I want to
do is to place a combo box on the form which lists the book categories
i.e. Science, Language, Travel so that when the user clicks on
Language for instance then all the books that appear in the Languag
category appear

any suggestions??

 

[Rick Brandt]

I have a form containing all the books in a bookstore what I want to
do is to place a combo box on the form which lists the book categories
i.e. Science, Language, Travel so that when the user clicks on
Language for instance then all the books that appear in the Languag
category appear

any suggestions??

Assuming the table has a field named "Category" in the AfterUpdate event of the
ComboBox have code...

Me.Filter = "Category = '" & Me!ComboBoxName & "'"
Me.FilterOn = True

 

[Raza]

Thanks for your reply Rick but unfortunately I'm still not getting
what I'm after. When I click on the Language category from the combo
box the records are filtered as they should be. However if i click on
Travel category then the records do not change they still show the
records for language category??

Raza