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

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

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.

You Might Also Like