search on multiple fields

[Pretty1996]

Hi guys I need a little advice/guidance with searching for a record based on multiple fields.

Basically I have a list box which I've set up to 'Find a record on my form based on a value I selected in my list box'

The problem I have is that it only returns a record based on 1 field.

so for example it will only return a record based on 'First Name' where as I'd like to base my return on both 'First Name' and 'Last Name'

I hope I'm making sense and I appreciate any advice you may have.

Thanks

 

[Montez659]

How is the search currently structured? Is it a query that returns search results, but based on a variable in a form? If so what you can do is in the design of the query use the "Or" line when entering criteria. Experiment with that a bit and see if that works.

Another thing that you can do is to concatenate the fields that you want to search, and then search that new concatenated field for the value that you are looking for.

Hope this gives you a bit of direction.

 

[jackd]

You may want to watch the free video tutorial here
http://www.datapigtechnologies.com/flashfiles/searchform.html

I agree with Montez659 that you may want to experiment with some OR conditions as well.

Good luck.