I have a question regarding making a button in my form that could pull from the "case#" field and show me a box to just enter in the case# and press ok and then pull the record that has that case# I specified. (like a parameter). Basically I have two Forms "STatusDos" and "ProblemDos". I need help in regard to this. Please explain in detail what to do and put because i am a newbie. Thank you for your help.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lookup records with Form button??????
- Thread starter jasonz
- Start date
Try this . . . this is the quick easy (kind of a pain) way, but it may work for ya. To create a filter form, someone else would have to help you out there.
In your database, go to the form you wish to search from. Once in the form, click on "RECORDS" then "FILTER" the "FILTER BY FORM", now go to the "CASE#" field you refered about, click on it and it (should) bring a drop menu down with all your case numbers, choose the one you want to work with, then go back to the toolbar and choose the "FILTER" option, then "APPLY FILTER/SORT" and Vuala, your Case# appears.
Dont forget, you may have to go back up to "FILTER" and choose "REMOVE FILTER/SORT" to view all your documents again, but play with it, and you'll get the hang of it.
To do this in code like I said someone else will have to do, if I find it somewhere I will let you know, but this will be a good start (hopefully) for you.
Good luck
Chance~
In your database, go to the form you wish to search from. Once in the form, click on "RECORDS" then "FILTER" the "FILTER BY FORM", now go to the "CASE#" field you refered about, click on it and it (should) bring a drop menu down with all your case numbers, choose the one you want to work with, then go back to the toolbar and choose the "FILTER" option, then "APPLY FILTER/SORT" and Vuala, your Case# appears.
Dont forget, you may have to go back up to "FILTER" and choose "REMOVE FILTER/SORT" to view all your documents again, but play with it, and you'll get the hang of it.
To do this in code like I said someone else will have to do, if I find it somewhere I will let you know, but this will be a good start (hopefully) for you.
Good luck
Chance~
- Status
