Filtering a report need help.

[illy2k]

I have been working on this database for a trucking company for some time now. When I first started all their Drivers were done through Social Security Number, but that got tedious, so i made a query to lookup driver SSN, then come back with the actual driver name. I am now working on a report, in which they want to type in a driver name, preferably last name, then it filters all the expenses from one table by a single driver. However, because of that lookup back to the Driver SSN, when you try to go by driver last name as it is in the table, it comes back with a parameter error. I set up the report to open a form when you click on it, this form has an area to enter a driver's last name, then through a query attached to the report, I set the expression for the drivers to equal the value typed in in the previous form, this is when I get the "enter parameter" box, giving me an error basically. Any ideas anyone? Is there anything I can do to change this, possibly using a macro. I need to associate the name that is typed in with a SSN, so the database can find a driver, and ideas?????

 

[mark curtis]

illy,

I have created a little demo for you and attached it. Give me a shout if you need more help?