filter current record with VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jay - 31 May 2007 16:30 GMT

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?

Reply to this Message

KARL DEWEY - 31 May 2007 17:10 GMT

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

If you have one record how can you filter?

Signature

KARL DEWEY
Build a little - Test a little

> i am trying to filter the current record by clicking "cmdUpdate".
> i have tried many many things.
[quoted text clipped - 11 lines]
>
>

Reply to this Message

jay - 31 May 2007 17:30 GMT

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.

> I am confused. How do you filter a single record.
>
[quoted text clipped - 15 lines]
> >
> >

Reply to this Message