Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filter Command
- Thread starter achiola
- Start date
- Thread starter
- #3
OK try something like this.
on the click event of your control
add this.
Dim strfilter as String
strfilter = "Open"
DoCmd.OpenForm "Myform", , , "myfieldbasedonOpen = " & strfilter
Hope this at least points you in the right direction.
Life's a journey enjoy the ride...
jazzz
on the click event of your control
add this.
Dim strfilter as String
strfilter = "Open"
DoCmd.OpenForm "Myform", , , "myfieldbasedonOpen = " & strfilter
Hope this at least points you in the right direction.
Life's a journey enjoy the ride...
jazzz
- Thread starter
- #5
Jazz,
It almost works... the problem is, my actual criteria is "a-open". When I put this into the code above a msgbox appears first with the letter "a" then another with "open". If I use the word "Open", then that word appears and I could type in my criteria "a-open" and it would work. Except I need it to automatically filter with just one click. Any ideas?
Nino
It almost works... the problem is, my actual criteria is "a-open". When I put this into the code above a msgbox appears first with the letter "a" then another with "open". If I use the word "Open", then that word appears and I could type in my criteria "a-open" and it would work. Except I need it to automatically filter with just one click. Any ideas?
Nino
- Status
Similar threads
