If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find Specific Data
I created a database in Access 2000 where it has a form that shows data on a
business. There are command buttons on that form; Contacts, Addidtional Information, ect. When you click the Contacts command button the Contacts form opens showing only contacts whose works for that business (there is a business text field on the Customers table with a drop down box to the business name from the Business table). The same is for the Additional information button and other buttons. This feature works just fine with Access 2000 and Access 2003. I put that database on a workstation with Access 2007 and that feature does not work. Even if I recreate the command button from within Access 2007. When the buttons are clicked it opens a window which is titles "Enter Parameter Value" and no matter what information I put in it will not show specific data (which would be Contacts just for that business which is shown in the current form). When any informaiton in put in the "Enter Parameter Value" it displays every contact (not limiting it to the current displayed business). Again, in all previous verions this works just fine. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Find Specific Data
Try putting in appropriate stop statements in your code to catch the point
where you can the sql that's being run at the point where your forms put up the request for a parameter. It may be you need to know the form recordsouce ( or the row source of a control within the form) that's being triggered. When the code stops go int immediate more and type ? me.recordsource or whatever or use debug.print . . .. to do it. Copy the sql then paste it into a new query and try running it. It then may be clearer what the problem is - you can play about with the query 'til it works for example. Jim Bunton "Corporate IS Solutions" Corporate IS Solutions @discussions.microsoft.com wrote in message ... I created a database in Access 2000 where it has a form that shows data on a business. There are command buttons on that form; Contacts, Addidtional Information, ect. When you click the Contacts command button the Contacts form opens showing only contacts whose works for that business (there is a business text field on the Customers table with a drop down box to the business name from the Business table). The same is for the Additional information button and other buttons. This feature works just fine with Access 2000 and Access 2003. I put that database on a workstation with Access 2007 and that feature does not work. Even if I recreate the command button from within Access 2007. When the buttons are clicked it opens a window which is titles "Enter Parameter Value" and no matter what information I put in it will not show specific data (which would be Contacts just for that business which is shown in the current form). When any informaiton in put in the "Enter Parameter Value" it displays every contact (not limiting it to the current displayed business). Again, in all previous verions this works just fine. Any help would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|