filter list box with a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Hull - 25 Nov 2006 16:00 GMT

I have a form with a combo Box in the main form that selects a record

In the sub form I have a list box that selects a record on the sub form

What I need to do is to have the list box to be filtered according what is

selected with the combo box on the main form

Reply to this Message

Arvin Meyer [MVP] - 25 Nov 2006 16:36 GMT

In the AfterUpdate event of the combo on the main form requery the list box:

Me.SubformControlName.Form.Requery

Set the criteria of the list box to:

[Forms]![MainFormName]![ComboBoxName]

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have a form with a combo Box in the main form that selects a record
>
[quoted text clipped - 3 lines]
>
> selected with the combo box on the main form

Reply to this Message