Multi-Table Form Shows "#Name?"

[SeaTigr]

Greetings all,

A quick thank-you to everybody who's responded to my other questions.

So,

Working on an inventory database that needs to store when security patches were applied to computers. Since more than one date needs to be stored (we want to keep a record of when every patch was applied), I created a separate table for the patch numbers and patch dates.

I created a form, added in the various widgets for the main equipment table with no problem. When I added in the two text boxes for the patch number and patch date, I set the control source as

=[Patch # and Date]![Unit IAVA Patch #]
=[Patch # and Date]![Unit IAVA Patch Date]

When I go to Form View mode, the boxes for the main equipment table are fine, but the two I had to set to the second table say "#Name?"

I've checked, and there are no unintended spaces before the "=" in the expression builder.

[alansidman]

A form can only be bound to one table or query. If you need to have a second table information appear, then you need to create a sub form that is bound to the second table. The mainform and the sub form are then linked via Parent/Child relationship.

Alan

[SeaTigr]

That worked, thank you. Another quick question: How do I turn off the border? I set border style to Transparent but there is still a line and shading on the left hand side of the subform when I switch to Form View.

[alansidman]

Set the border color to the same color as the subform.

[SeaTigr]

Thanks, Alan. I really appreciate your help.