=> Searching for a string in the database

[Rhonda Fischer]

Hello,

I'm not quite sure how to start whether it's a recordset
I need or a book mark?

My objective is to retrieve a string value 'surname'
from a text box on a form on the click event of a
command button called 'Search'. I then hope to find
this matching record in the database and populate the
fields on the same form where the surname was typed into.

In the instance where there is more than surname of the
same value I then hope to open a new 'continuous form'
listing these details.

Any ideas for a starting point would be terrific and
greatly appreciated.

Thank you muchly
Rhonda

 

[Albert D. Kallal]

If your database is not too large (say, only about 1000 records), then try
building a search combo box with the wizard.

It will create a combo box and you can search/select the surname. When you
do so, the form will move to that record.

Try building a combo box via the wizard. (to use the wizard, just bring up
your nice form in design mode, make sure the little magic wand is selected,
and then put a combo box on the forms "header". You will be prompted for
what type of combo box to make..select the 3rd option).