 |  |  |  |  |  |  |  |
FILTER QUERY results on a FORM?
 |
I hope this is the correct forum to post this.
Wondering if anyone could help...
On a form a continuous record list is displayed as results of running a QUERY.
While this QUERY is displayed, I’d like to filter it.
QUERY would display on a FORM showing: (customer: being the field name and jobdate: being the other field name) Well, control source since it's on a form?
customer jobdate
acne 1/1/07
acne 1/2/07
ace 1/3/07
acne 1/4/07
ace 1/4/07
On this form, a combo box will display the choices ACNE and ALL
From this FORM the QUERY is displayed on, I'd like to FILTER the form to toggle between showing ALL (as listed above) and JUST showing ACNE - without closing the form.
customer jobdate
acne 1/1/07
acne 1/2/07
acne 1/4/07
I have a combo box on the form that gives me 2 options to filter...either display ALL records the QUERY displayed originally or just show me records of customer “ACNE”
I'm hoping someone could provide the code I can place in the AfterUpdate (or AfterChange) portion...
Wondering if anyone could help...
On a form a continuous record list is displayed as results of running a QUERY.
While this QUERY is displayed, I’d like to filter it.
QUERY would display on a FORM showing: (customer: being the field name and jobdate: being the other field name) Well, control source since it's on a form?
customer jobdate
acne 1/1/07
acne 1/2/07
ace 1/3/07
acne 1/4/07
ace 1/4/07
On this form, a combo box will display the choices ACNE and ALL
From this FORM the QUERY is displayed on, I'd like to FILTER the form to toggle between showing ALL (as listed above) and JUST showing ACNE - without closing the form.
customer jobdate
acne 1/1/07
acne 1/2/07
acne 1/4/07
I have a combo box on the form that gives me 2 options to filter...either display ALL records the QUERY displayed originally or just show me records of customer “ACNE”
I'm hoping someone could provide the code I can place in the AfterUpdate (or AfterChange) portion...
|
Similar Threads
- test mysql query for no results (PHP)
- HELP: created dreamweaver form, but how do i get results from form? (PHP)
- pagination of mysql query results (PHP)
- Trying to return query results (ColdFusion)
- HTML Form post to PHP? (PHP)
- Dynamic Query (JSP)
- Showing results of a form in new window (HTML and CSS)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: serial to parallel conversion
- Next Thread: Multi lingual support for Crystal reports
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
