Search by name

J

Jade5

Hello:
I want the user to be able to search by name. Right now the user can search
by number based on a combo box input.

I have a combo box (Name Search Box) that has
Comp name comp id and corporation id
aaa 123 cd
abc 123 cd
dcc 111 aa

Comp Id is repeated in this list because the list is a combination of old
names and new names created from the SQL UNION of company table and history
table.
I have another combo box list that searches by Comp id and opens a form with
the following code:

If Not IsNull(Me.Combo3) Then
strWhere = "[Corporation ID] = """ & Me.Combo3.Column(1) & """"
DoCmd.OpenForm "Main form", WhereCondition:=strWhere
strWhere = "[comp ID] = """ & Me.Combo3 & """"

With Forms("Main form")![Company].Form
Set rs = .RecordsetClone
rs.FindFirst strWhere
Me.Combo3 = Null
.Bookmark = rs.Bookmark

How can I use the company name that the user enters in a the (Name Search
Box)combo box to search?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box/Forms 1
Sharepoint not capturing staff name when automation runs 0
Dynamic Naming of Form Button 3
Combo box selection opens form 1
Subform Search Function 2
Search combo box 2
Can I use a form to search and update data? 2
Require a field in search form 3

Top