Find a particular record

[ladie_36]

What i would like to do is if I have a database with a list of names and I want to find john smith. I want it to give me a list of all the smiths and then I double click on the name I want and it brings up his information.

Thanks

You could set up a list box where the box is loaded from a
sql command:

sql = "Select [FullName] from [XXX]where [LastName]="
sql=sql & chr(34) & passedvariable & chr$(34)
sql=sql & " Groupby [FullName]"

would give you the sql command:
Select [Fullname] from [XXX] where [LastName]="Smith" Groupby [FullName]

From there, it is a simple matter to select the proper name
and pass the index, or some other record identifier back to
the main program.

Good Luck
DerFarm