Filter a Listbox

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?

 

[Gene DeJoie]

Ive created a combo box for my list box both have OwnerID common
Just no quite right yet!
Regards Bob

Private Sub cmbFindClients_AfterUpdate()
Me.Filter = "OwnerID" & cmbFindClients.value


Me.FilterOn = True
End Sub

Thanks Douglas, That what I want to do , is there somewhere you can point
me to create this Scenario.............Thanks Bob

You mean you want to select something in the combo box and have that
limit what appears in the list box? No problem.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


I have a listbox that is based on a query, One of the fields in query is
[OwnerID]
Can I create a Combo box with [OwnerID] to filter my Listbox?