Searching the data

E

elli

Hi there, newbie here!
I have tried to solve my problem now for hours and haven't gotten any
closer.
I have made a form to show data in a table one by one. The table has more
than 2000 rows... So is there any way (simple please;)) to search and show
the specific row in my form??? Or even decide from two columns where to
search and find?

Sorry my messy explanation

-e-
 
R

Rick Brandt

elli said:
Hi there, newbie here!
I have tried to solve my problem now for hours and haven't gotten any
closer.
I have made a form to show data in a table one by one. The table has
more than 2000 rows... So is there any way (simple please;)) to
search and show the specific row in my form??? Or even decide from
two columns where to search and find?

Sorry my messy explanation
Click to expand...

The "simplest" way is to use the built-in find button on the toolbar. It will
have a binoculars icon.
 
E

elli

Hi Rick!
Y
That much I know, but I was kind of looking to make that kind of search into
my form...
Any help in there?
Sorry being non-specific.

-e-
 
R

Rick Brandt

elli said:
Hi Rick!
Y
That much I know, but I was kind of looking to make that kind of
search into my form...
Any help in there?
Sorry being non-specific.
Click to expand...

Well there is the Filter-by-form feature. Have you looked at that? If you drop
a new ComboBox on your form with the toolbox wizard enabled one of the choices
offered by the wizard will let you navigate (find) based on a selection made in
the ComboBox. The code that the wizard generates for that can easily be used as
a template to make your own variations on that theme.

Personally I prefer filtering to "finding" as it is more efficient.
 
E

elli

Hi Rick and thank U for your help.

I tied fiktering, but the column I'm planning to do the search has more than
3000 rows almost all data starting with AMNK...
So I was hoping there would be a solution like one text box where you could
write the specific item you want and the result (all of the info from that
item) would show up...

Impossible??

Thanks again:)

-elli-
 
Top