filter by VBA

[ironj32]

i am trying to filter a record by code. i have a form "frmVendorInfo", a text box "txtID" who's control source is "ID"
i want it to just filter the current record. i have tried:

Private sub cmdUpdate_click()

docomd.applyfilter ,
...CurrentRecord
...me.txtID.value
...txtID.value
...ID.value

nothing seems to filter any results. any suggestions?

[mattj]

Maybe try:

Me.Filter = "ID = " & Me.txtID
Me.FilterOn = True


HTH
Matt

[ironj32]

Thank You!!! that works.

[mattj]

Glad I could help!