form filter to show multiple records

[dcorleto]

I have a table with a field called LOCATION.

I would like to make a form where a user could input a location and click search, and all the records in that location would show up.

Can someone please give me a hint to jump start.

Thank you so much.


dc

 

[LonnieJohnson]

There is more than one way to do this. I will show you one.

1) Create a text box called txtSearch
2) Add a button called cmdSearch
3) Add another button called cmdUndoSearch
4) Put this in the click event of each button...

Private Sub cmdSearch_Click()
    Me.Filter = "CustomerID = " & txtSearch
    Me.FilterOn = True
End Sub

Private Sub cmdUndoSearch_Click()
    Me.FilterOn = False
End Sub

5) Put something in txtSearch and click the search button.

Hope this gets you started.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[dcorleto]

Works great. But what I need to be able to do is show all the records in that location. For example, if I have a location 03-42, I would like to be able to enter that location in the search box, and have it display the group of records that are associated with that location. For instance:

Location 03-42

CPU 8183
Monitor 545222
Printer HP4500

I imagine this is possible, but don't have a clue how to do it.

 

[LonnieJohnson]

Are you saying 03 through 42 or is 03-42 a single string like "03-42"?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[TheAceMan1]

How are ya dcorleto . . .

It appears the code given [blue]LonnieJohnson[/blue] need a slight modification:

[blue]    Me.Filter = "[purple][b][Location][/b][/purple] = '" & txtSearch & "'"[/blue]

See Ya! . . . . . .

 

[dcorleto]

03-42 is one location

Here is a sample list of 7 distinct locations

03-42
03-43A
03-43B
04-02
04-012A
04-12B
04-12V

 

[LonnieJohnson]

Oopps. Sorry about that. Thanks, TheAceMan1.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!