weird error with datasheet view only

M

Mark Andrews

I have a a form "formAccounts"
with a subform "formAccountInvoices" (subform control is named
"formAccountInvoices1")
with a sub form "formAccountInvoiceLines" (subform control is named
"formAccountInvoiceLines1"

On formAccountInvoices I have a text box that has this as control source:
=nz([frmAccountInvoiceLines1].[Form]![txtInvoiceLineTotal])

In form view the textbox seems to work fine and pulls the total of the
invoice lines (txtInvoiceLineTotal is in the footer of the
formAccountInvoiceLines form)

If I switch formAccountInvoices to datasheet view I sometimes get an #Error
and sometimes get the correct value in the text box.

Should I be doing something differently?

Thanks in advance for any help,
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to remove error from conflicting code 0
DLookup in Continuous form 0
Populate main form from subform record 0
Subform Datasheet Total Row 3
Creating a Search using a combo box and then creating a report. 4
Enlarge Datasheet Font, Rows in Form View 1
Unremovable horizontal scroll bar on subform 1
Excel does not accept text format! 0

Top