M
MAC
Hope someone can help me with this. I’ve been working on a freelance
writing database for some time now, and just have a couple of sticking
points before it’s done. I have a form called Main that contains
information about an article I’ve written, with a subform that shows
what magazine(s) I’ve sent it to and when, whether a check has come in,
etc.
I created an invoice report based on a query that transfers the
magazine’s name and address to the invoice. So far so good. But
depending on who assigned the article, I need to put that person’s name
on the invoice as well. That info is in another table called Contacts.
I’ve created a popup form that allows me to select which person at the
magazine should be the contact for that article, and select him or her
with a button. Everything works fine up to this point, but the person’s
name won’t appear on the invoice - I just get a #Name? error.
The form that pops up with the names is called InvContactSel Form, and
its subform (with the names) is InvContact subform. On the invoice, I’m
referring to the field I need on the subform (Fullname) as:
=[Forms]![InvContactSel Form]![SelContactForInv subform].[Form]![Fullname]
What am I doing wrong? Hope this wasn’t too long an explanation - just
wanted to get in all the facts.
Thanks,
Mark Cantrell
writing database for some time now, and just have a couple of sticking
points before it’s done. I have a form called Main that contains
information about an article I’ve written, with a subform that shows
what magazine(s) I’ve sent it to and when, whether a check has come in,
etc.
I created an invoice report based on a query that transfers the
magazine’s name and address to the invoice. So far so good. But
depending on who assigned the article, I need to put that person’s name
on the invoice as well. That info is in another table called Contacts.
I’ve created a popup form that allows me to select which person at the
magazine should be the contact for that article, and select him or her
with a button. Everything works fine up to this point, but the person’s
name won’t appear on the invoice - I just get a #Name? error.
The form that pops up with the names is called InvContactSel Form, and
its subform (with the names) is InvContact subform. On the invoice, I’m
referring to the field I need on the subform (Fullname) as:
=[Forms]![InvContactSel Form]![SelContactForInv subform].[Form]![Fullname]
What am I doing wrong? Hope this wasn’t too long an explanation - just
wanted to get in all the facts.
Thanks,
Mark Cantrell