Recent content by DeannaKate

Okay, the problem seems to be that the query involves several different tables. Once I put an Atty and Plgl field into tblLeadData and put them into the query instead of the corresponding fields from refAtty and refPlgl, the query filters just fine in the form. This solution, however, does...

I don't think Mihail's suggestion will fix my problem. The attorney and paralegal are people, but they fulfill different functions and need to be different fields. refAtty and refPlgl are just look up tables. I don't need to keep any other info about these folks except their names. (Others...

Thanks so much, Mihail. I'll consider your suggestion in the morning when I'm back at my desk. (I'm on the east coast of the U.S.)

Hi all... I've got a single form ("Lead Data") that has Cascading Combo boxes that work perfectly, entering data into "tblLeadData": cboMatterTypeID cboMatterID cboAttyID cboPlglID Attorney & Paralegal are the people assigned to the Matter. My problem is in finding a way to allow a specific...

Thanks much!

Hi all, I'm self taught and relatively new to Access. Pretty smart and logical, but Access is beyond me some of the time. So many ways that things can go wrong! :banghead: But so fun when you finally get it right. :D I'm a paralegal, trying to create a database that will track firm data...