Find Specific Data

[Corporate IS Solutions]

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.

 

[Jim Bunton]

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