Search Forms... I know... I'm not the only one!

Ok...

There are lots of threads relating to this... but i cant seem to find one that points me accurately enough in the right direction... hence my need for assistance!

I need to create a search form that looks up data over about 8 or 9 fields in anoter table and then brings back all relevant records. I need the user to be able to enter data either into either one or all of these fields and then for all of the relevant records to be displayed in another form called 'Property' that the search form, 'Search Form' is based upon.

The search form is practically a copy of the main 'Property' form but with all unbound combos... I managed to work out from other threads that this was what I needed to do.

What I need now is someone nice and friendly to help me write a bit of code.

Hope i've made this clear enough.

My Search Form is called 'Search Form' and my Main form is called 'Property' . The 'Property' form is linked to a table called 'House Details'

The Fields on the search form are 'Reference', 'Total €', 'Number of Beds', 'Location', 'Condition', 'Land', 'Street of Hamlet' and 'Availability'

SOMEONE HELP!!

All responses greatly, greatly appreciated!

Thanking you in advance!

Try putting this in the criteria for each field but on seperate lines (Or):
Like "*" & [Forms]![Search Form]![txtSearchString] & "*"
You will need only one txtSearchString field inthe form.

Originally Posted by ollygregory

Ok...

There are lots of threads relating to this... but i cant seem to find one that points me accurately enough in the right direction... hence my need for assistance!

I need to create a search form that looks up data over about 8 or 9 fields in anoter table and then brings back all relevant records. I need the user to be able to enter data either into either one or all of these fields and then for all of the relevant records to be displayed in another form called 'Property' that the search form, 'Search Form' is based upon.

The search form is practically a copy of the main 'Property' form but with all unbound combos... I managed to work out from other threads that this was what I needed to do.

What I need now is someone nice and friendly to help me write a bit of code.

Hope i've made this clear enough.

My Search Form is called 'Search Form' and my Main form is called 'Property' . The 'Property' form is linked to a table called 'House Details'

The Fields on the search form are 'Reference', 'Total €', 'Number of Beds', 'Location', 'Condition', 'Land', 'Street of Hamlet' and 'Availability'

SOMEONE HELP!!

All responses greatly, greatly appreciated!

Thanking you in advance!

Excuse my ignorance... but I assume you mean entering...

Like "*" & [Forms]![Search Form]![txtSearchString] & "*"

into a query?

Well if thats right, then I tried that, and it seemed to bring back the values I would expect... but how do i get them displayed in the 'Property' form, as if they've just been filtered..?

Thank you for your assistance so far

Originally Posted by Bob Miller

Try putting this in the criteria for each field but on seperate lines (Or):
Like "*" & [Forms]![Search Form]![txtSearchString] & "*"Like "*" & [Forms]![Search Form]![txtSearchString] & "*"

You will need only one txtSearchString field inthe form.