Combo and list box help

[lcboley]

I have a small database to track childrens books for a Preschool. I am keeping the database as simple as possible for the director.

I have 3 tables
Book_Information
Authors
Book_Category

I have relationships established and a form for them to enter data easily into. I used the OnNotInList code from this Forum and it works great for them typing in Authors and Book_Categories on the form.

What I want to do now is have a form that has a Book_Category combo box for them to select a category and display the results on the same form in a list box. Basically a book lookup form. Would be nice for them to search by author also.

I have downloaded SJ McAbney's combo box sample database but I just couldnt make the connection between the combo box and displaying multiple rows in the list box.

Again, thanks in advance for all of the help.

lcboley

 

[PARSO]

somthing like this??

 

[lcboley]

Much like that

From your example, I got my drop down search to work. It displays in a query window.
I would like to have it display on the same form below where the seach combo box is. I am thinking in a list box.
Just so that is looks cleaner. Also I dont want them to be able to edit any of the records.

Thanks.

 

[daveUK]

I've changed the example that PARSO posted and it should now do what you want.

HTH