filter current record with VBA

J

jay

i am trying to filter the current record by clicking "cmdUpdate".
i have tried many many things.

Private sub cmdUpdate_click()

docmd.applyfilter ,
....CurrentRecord
....me.txtID.value
....txtID.value
....ID.value
...etc..

nothing seems to filter any results. any suggestions?
 
K

KARL DEWEY

I am confused. How do you filter a single record.

If you have one record how can you filter?
 
J

jay

I have form that takes info from a query. None of the data can be edited. I
want to click "cmdUpdate" to filter the current record...or filter the
autonumber "ID", which is displayed in "txtID" for the current record). and i
am then going to set the setting to allow it to be edited. Basically I just
want to single out the current record I am viewing, if that makes sense.
 
Top