How to Remove Filter and Stay on Same Record

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
 
T

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

Look up the .Bookmark property in Help.


Tim F
 
D

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
 
Top