Record location without command button wizard

[Saur Braen]

I would like to find records easily, without using the
find/find next command button wizard option. Preferably
i would like to enter my client's IDnumber, or name if
possible, into a text box and have the form return/goto
their data.

Alternatively I can enter the data and then click on a
command button that has code behind it that tells the
form to go to that record.

Is it possible??

- I'm just not very satisfied with the Find/FindNext
option.

Much gratitude, glee and satisfaction assured for the
solvee..

Thanks

 

[Albert D. Kallal]

You can use the wizard to make a search combo box.

I would try placing it in the forms header part.

If you database small (1000 record range), then a comb box works quite well.

if you database is medium size. Say, 50,000 records, then a combo box is too
big.

Try the combo wizard, it is start.

If you are willing to write some code, then you can start creating search
forms. They are more work, but the results are much better.

You can look at the following screen shots to get an idea of what I mean:

http://www.attcanada.net/~kallal.msn/Search/index.html

 

[Albert D. Kallal]

You can use the wizard to make a search combo box.

I would try placing it in the forms header part.

If you database small (1000 record range), then a comb box works quite well.

if you database is medium size. Say, 50,000 records, then a combo box is too
big.

Try the combo wizard, it is start.

If you are willing to write some code, then you can start creating search
forms. They are more work, but the results are much better.

You can look at the following screen shots to get an idea of what I mean:

http://www.attcanada.net/~kallal.msn/Search/index.html