Textbox search in form - going through more than one record

oni1983

New Member
Joined
Jul 9, 2015
Messages
25
I have a form which basically is intended to serve as a summary of many of the data I have in my database.

I have followed one of the posts here and managed to get a functional textbox search in my form. However my difficulty is this:

The searchbox available at the bottom of the form allow you to go through through different records containing the same data (for example the same surname) by pressing Enter.

However the textbox search only shows one record. How can I use this to go through all records showing the same data, just like the searchbox available at the bottom?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
the form should be showing many records set with default view= CONTINUOUS FORMS.
in the textbox afterupdate event, filter the records to show all that match

me.filter = "[field] = '" & textbox & "'"
me.filterOn = true
 
Upvote 0

Forum statistics

Threads
1,221,846
Messages
6,162,376
Members
451,760
Latest member
samue Thon Ajaladin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top