Lookup using 2 form fields 1

[cimoli]

I was wondering if there are any whitepapers or posts for the following lookup condition.

I have a subform for People who are on the trip. (The main form being the reservation.)

Because we have 230,000 possible customers, I need to do something we used to have.

1 - I would enter the lastname or partial lastname of a person in a field called txtTypeName

2 - Then i move the click on the next subform cboNameSearch field and click on the down arrow
to get the CusID.

Up would come a list of possible customers with that last name shown in txtTypeName.

I would pick one. Then the CusID would show in cboNameSearch.

This procedure helped get around the 230,000 people problem.

thanks you.

 

[Andrzejek]

enter the lastname or partial lastname of a person in a field called txtTypeName

You can create something like:
[tt]
strSQL = "SELECT * FROM MyTable WHERE " _
& " LastName LIKE '*" & txtTypeName & "*'"[/tt]

Have fun.

---- Andy