How to find next searched record ???

[ksor]

I use that little seach box in the buttom of a form and I enter a criteria.

It finds THE FIRST record meeting the criteria - that's nice BUT ...

How do I goto THE NEXT record that meets the criteria ?

[andy49]

Do you mean Click on the record counter to the next one?


Sent from my iPhone using Tapatalk

[ksor]

No I mean when entering mu search text the selection jumps around records til it finds the FIRST instance and STOPS there.

I know the one record I'm searching for is "down there" but outside the window - how do I get down there ?

[andy49]

Ok well the form data is everyone so you get the first time the data is found. Then it just moves on.

Might be easier creating your own search box where you can set the form filter using the data you're searching for.


Sent from my iPhone using Tapatalk

[ksor]

Ok well the form data is everyone so you get the first time the data is found. Then it just moves on.

Might be easier creating your own search box where you can set the form filter using the data you're searching for.


Sent from my iPhone using Tapatalk

That MS search box is worth nothing at all, I think

But thx for your comments

[CJ_London]

are you looking for the same functionality you get by clicking on a control then ctrl-F?

[orange]

I use that little seach box in the buttom of a form and I enter a criteria.

With so little context in your post, I think Andy has offered an option --build your own search form.

You might find this free youtube video useful.

[ksor]

Yeah, a little simple seach - why the button use change event on the txtBox instead

The seachbox from MS is just for shitting !

[orange]

It's a starting point.
Google MS Access search and you'll find many ways to "skin the cat".
A lot depends on your requirements, experience and who will use it.

Allen Browne often referenced search info
MultiSearch often seen in posts

Find as you type --narrow the list approach