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.