Searching for a record using two fields based on full/partial info

[Rob M]

Hi all,

I'm trying to set up a procedure that seems like it should be simple - but I
can't figure it out.

I have a table called demographics with separate columns for last name,
first name, birth date, address, etc. I have a search form with two text
boxes. I'm trying to create search capabilities based on last name and/or
first name, either with full or partial entries, using two text boxes. For
example, using the search form, I'd like to access John Smith's record
(displayed in a separate "Main" form) by typing in...

Textbox1 Textbox2
Smith John
Smith
Sm John
Smi Jo

....etc.

Does anyone have any suggestions on how to perform this? Or are there any
downloadable code excerpts available? I'm a noob muddling my way through
this...I would be grateful for any help.

Thank you,
Rob

 

[John W. Vinson]

Hi all,

I'm trying to set up a procedure that seems like it should be simple - but I
can't figure it out.

I have a table called demographics with separate columns for last name,
first name, birth date, address, etc. I have a search form with two text
boxes. I'm trying to create search capabilities based on last name and/or
first name, either with full or partial entries, using two text boxes. For
example, using the search form, I'd like to access John Smith's record
(displayed in a separate "Main" form) by typing in...

Textbox1 Textbox2
Smith John
Smith
Sm John
Smi Jo

...etc.

Does anyone have any suggestions on how to perform this? Or are there any
downloadable code excerpts available? I'm a noob muddling my way through
this...I would be grateful for any help.

Thank you,
Rob

Put a criterion on LastName of

LIKE [Forms]![Searchform]![Textbox1] & "*"

and on FirstName

LIKE [Forms]![Searchform]![Textbox2] & "*"

 

[Rob M]

Hi John,

Many thanks, this is what I needed!

Cheers,
Rob

Hi all,

I'm trying to set up a procedure that seems like it should be simple - but
I
can't figure it out.

I have a table called demographics with separate columns for last name,
first name, birth date, address, etc. I have a search form with two text
boxes. I'm trying to create search capabilities based on last name and/or
first name, either with full or partial entries, using two text boxes.
For
example, using the search form, I'd like to access John Smith's record
(displayed in a separate "Main" form) by typing in...

Textbox1 Textbox2
Smith John
Smith
Sm John
Smi Jo

...etc.

Does anyone have any suggestions on how to perform this? Or are there any
downloadable code excerpts available? I'm a noob muddling my way through
this...I would be grateful for any help.

Thank you,
Rob

Put a criterion on LastName of

LIKE [Forms]![Searchform]![Textbox1] & "*"

and on FirstName

LIKE [Forms]![Searchform]![Textbox2] & "*"