in Lesson number 10, around 10 minutes in, where we seek to link the Company name in OrderR to the MainMenuForm (System Default), the Company Name in the OrderR indicates the error message: #Name?. I entered =[Forms]![MainMenuForm]![CompanyName] in the Textbox Control Source, so it looks right to me.... Any assistance is appreciated.
regards,
Andrew
Kevin Robertson
@Reply 3 years ago
Are you using the same names for your objects as Richard did in the video? Is so the name of the form should be MainMenuF NOT MainMenuForm.
Andrew GreshamOP
@Reply 3 years ago
Many thanks Kevin. I have renamed the Object to Richard's convention. 8from the drop down menu when building the formula it now reads =[Forms]![MainMenuF]![CompanyName]. I still have the issue though. Actually what is interesting, when I link to some other Forms, sometimes, but not always, I can get the text box to update.
Andrew GreshamOP
@Reply 3 years ago
Now, that I have moved to using DLOOKUP to populate the text box, it is working fine. Let us consider the case closed. Thanks again, Andrew
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 10.
