How to Remove Filter and Stay on Same Record

  • Thread starter Thread starter doyle60
  • Start date Start date
D

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
 
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.
Click to expand...

Look up the .Bookmark property in Help.


Tim F
 
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
 
Back
Top