Search box that shows result in Form

[revvedmoto]

Here's a description of what Im trying to do.

Currently I use a vendors website to search for products by description and brands to gather data such as part number, price and availability. This data is then used to create a new entry in my table.

My vendor has supplied me with an excel file with all the info I need but need a quick way to sort through it.

What would be Ideal is to create a form that had a quick search function on the top half that showed my search results that would help me fill out the bottom half.

I have two columns to search through Description and Band. Here is an example

JACKET CONTRA SLATE MD | Icon


My problem is that I have little to no experience with coding so Ive been looking for some example to base this off.



Any advice would be greatly appreciated!!

[June7]

Set up the form as Continuous View. Put unbound search controls in the Header section.

Options:

1. parameterized query, review http://www.datapigtechnologies.com/f...tomfilter.html

2. VBA code that builds filter criteria string and applies to the form Filter property, review http://www.allenbrowne.com/ser-62code.html

[revvedmoto]

Sorry I might of miss represented what Im after. Im trying to search from the Main form to a subform. At this point Ive tried to rework several examples that Ive found on other forums with no luck. Im sure Im missing something small.
I think what would be ideal is A search box that I can type a general search in and also have a Combo box that will narrow down the brand.
example:

Search: Jacket Brand: Icon

results
||||||||||Item|||||||||||||Brand
JACKET CONTRA SLATE MD | Icon

[June7]

Still think the referenced links are relevant.

Here's another http://www.datapigtechnologies.com/f...combobox2.html

[revvedmoto]

Awesome thanks for the help, I managed to get the combobox created and working but sense I sell many items of the same brand my combobox has many duplicates. Is there any way to get rid of the duplicates?

Now on to the search function!!

[revvedmoto]

Scratch that found it under row source of the combobox and properties.

[revvedmoto]

Well Im kind of stuck on the search button. Im trying to get it to search "Description". I could be way off but this is what Ive tried:

Private Sub wpssearch_AfterUpdate()
Dim strWhere As String




If Not IsNull(Me.wpssearch) Then
strWhere = strWhere & "(Forms!wpsinventory![wps subform].Form!Description Like ""*" & Me.wpssearch & "*"") AND "


End If


End Sub

[June7]

That is option 2.

That approach sets the Filter and FilterOn properties of the form. Review the link again and then complete the procedure.

I always give subform container control a name different from the object it holds, like ctrDetails.

If you build a search criteria based on only one field, could be simply:

Me.ctrDetails.Form.Filter = "Description Like ""*" & Me.wpssearch & "*"""
Me.ctrDetails.Form.FilterOn = True

[revvedmoto]

great that works. So what if I wanted to take this one step further? Currently If i search for a multi word phrase it searches for that exact phrase. For example If I was trying to find this listing
"KINETIC RACE PANT YELLOW/BLACK SZ 18"
It wouldnt be found if I searched "Kinetic Pant"

[revvedmoto]

http://www.access-programmers.co.uk/...d.php?t=163512

I found this link that might work for me but Im not sure how I would implement it into my current code.

[June7]

Would have to break up the string "Kinetic Pant" and build multi-value criteria. The result would be:

"Description LIKE ""*Kinetic*"" OR Description LIKE ""*Pant*"""

[82280zx]

revvedmoto

You can try doing what I just did and see if thats what your looking for. Select WPS Subform Form and go the the property sheet, select the Data Tab, in Filter put [nameofdescriptioncolumn] Like '**'
then select your wpsearch text box and go to it's property sheet, go to on change and put this in

Private Sub wpssearch_OnChange()

WPS Subform.Form.Filter = "[nameofdescriptioncolumn] like '*" & wpssearch.Text & "*'"
WPS Subform.Form.FilterOn = True

End Sub

Thats if your subform is named WPS Subform I'm going off the data from your screenshot above.

Thanks again June7 btw!

[revvedmoto]

Honestly I Pretty much have the same thing already but I appreciate the help.
what I would like it to do is filter for the first word then filter those results with another word

[June7]

I've never tried to program sequential filtering.

Did you understand post 11?

[revvedmoto]

Actually I didnt see #11 must of skipped right over it. This is what I tried with no luck.

Private Sub wpssearch_AfterUpdate()
Me.[wps subform].Form.Filter = "Description Like ""*" & Me.wpssearch.Text & "*""" Or "Description Like ""*" & Me.wpssearch.Text & "*"""
Me.[wps subform].Form.FilterOn = True
End Sub