Recent content by brandywinefarm

Thank you. I finally got it all working.

I used to do access databases years ago and am restarting so I am very rusty...and I'm getting older so there's that :/ Facts: Contacts Table ("people") Std contact table...Names, email, phone, whether they are a client or Partner, Status, Spouse name, Parter company (if) Course Table...

That works. Please help me understand. Before I tried to use ISNULL to return a "" into the field but it never worked. Isn't it proper to use ISNULL on a blank integer field?

Hello. I have a form that has a drop down box that looks up the referrerID from a contact table (integer). Then I have an unbound field that reports that person's name for the user. It works fine. However, if there is no one that referred that client, the referrerID field is null and so the...