I solved my previous problem only to create another. My SvcAuthQuery included two fields for ClientID - one each from the two tables because that is the related field. So, I removed the one from the SvcAuthTable and it worked. My button now goes to the appropriate client's SvcAuthForm; however, it will not let me input data now. I get an error that reads: 'Cannot add record(s); join key of table "SvcAuthTable" not in record set.' Feels like a Catch-22. Please help.

---

Reply from Richard Rost:

Sounds like you've made the underlying query too complex. You'll have to simplify it.