About Geoff Expertise I specialise in database analysis and design, SQL and database queries using QBE and VBA. In my work, I use MS Access together with MS SQL Server as ETL (Extraction - Transformation - Loading) tools for migrating data between business ERP systems and data stores. My forte is building bespoke functions and applications.
See my
website for example apps and downloads
Experience I am a chartered engineer with 30 years of engineering and business experience, member of the BCS and have been working specifically in database applications, including SQL Server (v7/8/2000) for the last 9 or so years. I previously taught a course in Database Analysis and Design, but am now a freelance consultant and systems analyst.
Commercial database design and development work undertaken.
Question First i want to thank you in advance for your help.
My question is as follows. i have an Ms Access database that i already entered data in it . But my supervisors need to do a Double data entry to it so i need the database to automatically check with the original Table and tells me if what I’m entering does not match the original Table and if i want to change the original Master table .
I did a copy of the form called it (form2) and a copy of the table called it (table2) but don’t know what to do next I’m not an expert but I use a little VB to make simple codes to open close fields .
Please help me i will really appreciate it soo much please
Thanks in advance
Answer Charles, hi
Open Form2 in design mode
Open the Properties dialog (RH click & Properties)
Ensure the form object is selected - box at top-left of form object is black.
In the properties dialog - find RecordSource property - change this from table1 to table2
