how to display records on a form based on a listbox

[illusionek]

Hello,

I designed a simple form that has a listbox and a subform. I am using Northwind database for testing.

I would like to be able to display on a subform only records based on a value of a list box.

I created a listbox using a wizard and selected an option 'find a record on my form based on the value I selected in my list box'. This kind of works but it does not display all records matching criteria.

Attached print screen 1 shows my table and there are six records for 'Las Vegas' but my sub-form displays only three for Karen Toh (print screen 2) and all records for John Edwards are missing. I am not really sure how to fix this problem.

Ideally I would like to take this a step further and do another list box with Last Name and then filter data even further down so for example if I select Last Vegas and Edwards then the form would show me only matching records.


I will be very grateful for any suggestions

 

[pbaldy]

Make sure the code or macro behind the listbox is using the correct column/field to filter on.

 

[illusionek]

You are right that was a silly mistake to make but then how can I use two listboxes simultaneously?

I cannot link sub-form to two different Master/Child fields, so now if I use City list box and select Las Vegas everything works well but I then if I add another listbox with Last Name it just does not work.

Any suggestions?

Many thanks.

 

[pbaldy]

You could use a query with criteria like this:

http://access.mvps.org/access/queries/qry0001.htm

and requery the subform when selections are made. For more than a couple, I tend to create dynamic SQL, as shown in the sample db here:

http://www.baldyweb.com/BuildSQL.htm