I am trying to use a subform to update an inventory transactions log. There are two tables, "Inventory", and "Daily Transactions". The main form contains an unbound control which is used to find the stock number in the Inventory table. The subform has the date, quantity and price. When I try to use a macro attached to a button on the subform to update the date in the Daily Transaction table from the unbound control I get the following error: "The object doesn't contain the automation object "Daily Transactions".
I don't know it this is significant, but I have reviewed the KB article on referring to controls in subforms and I have tried alternate interpretations of the syntax, but my Access will not leave the syntax ".Form![Date]" but changes it to ".[Form]!Date".