Filtering Records on a Form 2

[primagic]

I am trying to filter the records on a form by using a listbox

I have a listbox which when a record is selected is populates the select key field to a textbox

I then have the following code to apply the filter but I am getting a data type mismatch error

DoCmd.ApplyFilter , "ID = '" & txtSelectedRecord & "'"
Me.FilterOn = True

 

[ZmrAbdulla]

Your ID column might be numerical type.

"ID = " & txtSelectedRecord

or

"ID = " & Cint(txtSelectedRecord)

will do it

Zameer Abdulla

 

[TheAceMan1]

How are ya primagic . . .

Try

[blue]   Me.FilterOn = False
   Me.Filter = "ID = " & Me.[purple][B][I]YourListBoxName[/I][/B][/purple].Column(0)
   Me.FilterOn = True[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]