Search on Last and first name

[Debbiedo]

I am trying to set up a search feature in an Access form that narrows
the display of selectable options as you type in more information.

I have the basic idea of how to do "starts with" searches for a given
field. What I do not know how to do is combine the results of two
search fields, display the results, and then interatively select the
correct record based on the results displayed.

Thus, I can create a search that selects all records that has the
LastName beginning with Smith.
I can also create a search that has records where the FirstName begins
with Jo but...

How can I combine these to display all records that contain these two
search results and then from these results pick the correct record to
then display in a report. (e.g Jon Smith-Edwards) The problem is that
there can variations on how the data entry people spell a person's
name and I need a search engine that captures these variations and
ultimately return a single record to display in a report.

Many thanks

Deb

 

[Jae]

The below link teaches you how to use this function called "in select"
statement in parameter. Study that video and you should be able to accomplish
what you are looking for.

http://www.datapigtechnologies.com/flashfiles/deleteproblem.html

 

[Debbiedo]

The below link teaches you how to use this function called "in select"
statement in parameter. Study that video and you should be able to accomplish
what you are looking for.

http://www.datapigtechnologies.com/flashfiles/deleteproblem.html










- Show quoted text -

I kind of see how this might work, I think I can do this by creating a
firstname combo box to pass this info into using the Select In clause.
Correct? But then how can I get the results to show up and then select
the correct record?

Lets say I've narrowed the search results down to 3 John Smiths. From
here the only way I can determine which John Smith I want is to
examine the results of my search query. How do I display the results
in a format that I can interactively select it from within the form
and display this record in the report?

i.e. I want to click on a record that is contained within the query
results that is somehow displayed in the form or in an associated
popup form and then have that record displayed in a report. Make sense?

 

[Jae]

To assist you further, I need to know how you are doing your search. Can you
copy paste your vab/sql?

 

[Jae]

By the way, there's actually better ways to do a search using dynamic sql.
Here's sample that Mr. Allen Browne did.

http://allenbrowne.com/ser-62.html

 

[Debbiedo]

Hi -

See Allen Browne's 'Search as you Type' athttp://allenbrowne.com/AppFindAsUType.html.

HTH - Bob

By the way, there's actually better ways to do a search using dynamic sql..
Here's sample that Mr. Allen Browne did.

http://allenbrowne.com/ser-62.html

The below link teaches you how to use this function called "in select"
statement in parameter. Study that video and you should be able to accomplish

[quoted text clipped - 42 lines]

results that is somehow displayed in the form or in an associated
popup form and then have that record displayed in a report. Make sense?

This link helps a lot. Thanks.