How to Remove Filter and Stay on Same Record

[doyle60]

I need code that will remove the filter (the funnel light being on) and
keep on the same record. Currently, removing the filter makes the form
jump to the first record.

Thanks,

Matt

 

[Tim Ferguson]

I need code that will remove the filter (the funnel light being on) and
keep on the same record. Currently, removing the filter makes the form
jump to the first record.

Look up the .Bookmark property in Help.


Tim F

 

[doyle60]

Thanks. I got it to work.

I needed to change a line in my code from

stLink Criteria = "[CBID]=" & "'" & Me![CBID] & "'"

to

stLink Criteria = "[CBID]=" & Me!CBID]

This solved a "Data type mismatch in criteria Expression" error.

Thanks,

Matt