list box based on combo box

[crowegreg]

Within a form, I have a combo box and a list box. Here is the row source for the list box:

SELECT tblWellData.WellID, tblWellData.CurrentWellName, tblWellData.CurrentOperator FROM tblWellData ORDER BY tblWellData.CurrentWellName;



This displays all the records within the table. If I only want the records based on the selection within the combo box, this is the row source:

SELECT tblWellData.WellID, tblWellData.CurrentWellName, tblWellData.CurrentOperator FROM tblWellData WHERE (((tblWellData.CurrentOperator)=[Forms]![frmTestForm]![Combo4])) ORDER BY tblWellData.CurrentWellName;

It displays 0 records. What am I doing wrong?

[jzwp11]

What is the row source of the combo box? What is the bound field of the combo box?

[crowegreg]

Thank you for your quick reply.
Here is the row source for the combo box:
SELECT tblWellData.CurrentOperator FROM tblWellData GROUP BY tblWellData.CurrentOperator ORDER BY tblWellData.CurrentOperator;

Bound column is 1

[jzwp11]

In the after update event of the combo box, you need to requery the list box. The code would be as follows (you will have to substitute your actual list box name)

me.listboxname.requery

[crowegreg]

Within the gotfocus of the listbox, I have me.requery. What's the difference between that and what you suggested?

[crowegreg]

Your suggestion worked!! Thank you!!

What's the difference between where the requery is done?

[jzwp11]

The after update event fires after a selection is made in the combo box. Since your list box depends on that value that event that will provide the WHERE clause with the value it needs. I did some experimenting and the code seems to work in the on click event as well.

I use the after update event since it has been referenced on other websites, but like other things, there may be multiple ways to do things in Access.

[crowegreg]

Within the form, I have other combo boxes source dependant upon another combo box. I've been using the requery within the gotfocus, and they work correctly. Thanks again for your assistance!!

[jzwp11]

Now I've learned something new! Thanks