 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / November 2007Filter Information.
I have a Form that pulls information from different tables and queries but I would like to be able to filter only certain information if its possible. here is what I currently do. I have a mainboard with buttons. I click a button to open the Form. The Form shows job numbers, record numbers, and other information. I than have to use the next/previous buttons or the search to find information. what I would like to be able to do is only show the information for a selected job number or when I click the button to open the Form have it ask me for the job number and than only show that job information. Place a criteria prompt in the query that is the source for the form like this -- [Enter Job Number] Or for a sequence of job numbers like this -- Between [Enter Beginning Job Number] AND [Enter Ending Job Number] Or to enter just the start of job number -- Like [Enter Job Number] & "*"  SignatureKARL DEWEY Build a little - Test a little > I have a Form that pulls information from different tables and queries but I > would like to be able to filter only certain information if its possible. [quoted text clipped - 5 lines] > the Form have it ask me for the job number and than only show that job > information. That works great. Thank you. > Place a criteria prompt in the query that is the source for the form like > this -- [quoted text clipped - 16 lines] >> the Form have it ask me for the job number and than only show that job >> information. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.