strlastname =3D request.form("yourforminput")   'ne for this example
customer LIKE '" & strlastname & "%'"

Or...
"Select customer From Customers where customer LIKE 'ne%'"

-----Original Message-----
From: Jamaal Sabdul [mailto:jamfl_1999@y...]
Sent: Friday, June 28, 2002 8:37 AM
To: ASP Databases
Subject: [asp_databases] Searching


I am trying to search a data base in access using vb,...i want to be
able
to enter for example "ne*" and return all results that match in a list
box. Does anyone know the coding for that? In access i have a table
called
Customers with say 20 customers that begin with "ne".I want a box that
asks for a name or partial and finds all the names that match the search

criteria and displays results in a box...list or whatever. PLease help.

I am trying to search a data base in access using vb,...i want to be able 
to enter for example "ne*" and return all results that match in a list 
box. Does anyone know the coding for that? In access i have a table called 
Customers with say 20 customers that begin with "ne".I want a box that 
asks for a name or partial and finds all the names that match the search 
criteria and displays results in a box...list or whatever. PLease help.