Hi all,
I'm working on fixing one of the databases at work, it wasn't displaying the client name or site address when a text field was added, only the clientID & siteID numbers were displayed, to get it to display the client name & site address how it should I used the below DLookUp code as the control source of new text boxes
Both work as they should & display what should be displayed, it creates a new problem though, the bottom row of the list form that has blank fields with "New" on the job number field has "#Error" in both the bottom Client & Site address boxes
Is there a way to remove the "#Error" text or even remove the blank line with nothing in it if that would be easier?
Edit - Just sussed it out, I set allow additions to "No", thought I'd tried that but I changed the wrong setting
I'm working on fixing one of the databases at work, it wasn't displaying the client name or site address when a text field was added, only the clientID & siteID numbers were displayed, to get it to display the client name & site address how it should I used the below DLookUp code as the control source of new text boxes
Code:
=DLookUp("ClientName","tblClients","ClientID=" & [Client])
&
=DLookUp("SiteAddress","tblClientSiteAddresses","SiteID=" & [SiteAddress])
Both work as they should & display what should be displayed, it creates a new problem though, the bottom row of the list form that has blank fields with "New" on the job number field has "#Error" in both the bottom Client & Site address boxes
Is there a way to remove the "#Error" text or even remove the blank line with nothing in it if that would be easier?
Edit - Just sussed it out, I set allow additions to "No", thought I'd tried that but I changed the wrong setting
Last edited: