I Have Encountered #Name? Error in Access Form

In Access Database I have main Form named "frmMain" and child form "frmPaymentsToAllAccountsTotal". The Child form is continuous Form I create a textbox on Main form and named "mrdPayments". In the control source of this text box I enter this expression =[Forms]![frmPaymentsToAllAccountsTotal]![AnasT], where "AnasT" is textbox in footer of sub form. Whenever I go to form view. I got #name? error. Please note that there is no space before and after the field name, form name. I notice when I open child form separately then mrdPayments showing value as expected but as I close the sub form even sub form is already placed on Main form, then mrdPayments value changes to #name? error.

I am using MS Access 2019, 64 bit version on Windows 10

Thanks

1 Answer

I changed control of mrdPayments from =[Forms]![frmPaymentsToAllAccountsTotal]![AnasT] to =[frmPaymentsToAllAccountsTotal].[Form]![AnasT] on Main Form and my problem solved.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Marcus Vance

Marcus Vance

Cybersecurity & Digital Privacy Researcher

Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.

Share this article
Twitter Facebook Pinterest