K
KellieC
I'm trying to modify the Access 2007 inventory database template for my needs.
The form "Inventory Details" has a text box labeled "History" with the code
"=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))". This works
great with the template set-up, which only has one table as the recordsource
for the form. I want to add some fields to the form from another, related
table, but as soon as I add the second table to the recordsource the
"History" box just says "#Error". I'm having the same problem with another
box on the form that has "=DSum("[Actual Quantity]","[Inventory Transactions
Extended]","[Inventory.ID] = " & [ID])". Does anyone know how to fix this?
Thanks!
The form "Inventory Details" has a text box labeled "History" with the code
"=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))". This works
great with the template set-up, which only has one table as the recordsource
for the form. I want to add some fields to the form from another, related
table, but as soon as I add the second table to the recordsource the
"History" box just says "#Error". I'm having the same problem with another
box on the form that has "=DSum("[Actual Quantity]","[Inventory Transactions
Extended]","[Inventory.ID] = " & [ID])". Does anyone know how to fix this?
Thanks!