Hi there,
I am currently building a database in which users can see certain Site Locations and when they click on it, it'll open up to the Site Details. So I made two forms: "Site List" and "Site Details". When I tried to link the two together using the "OpenForm" macro "on click" it gives me two errors that I pasted print screens into a word document of. I made sure there was a PK and I wanted to make sure that the site that is clicked, opens to the right site details form so I added in the function an "=[Site ID]"... But it still isn't working. Please refer to the Word document for the error messages and also to see which macro I am trying to use.AccessErrors.zipAccessErrors.zip
Any help would be much appreciated!!