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.
I tried what you suggested a few days ago and it worked partially. I was the one who was trying to tab between two sub forms, one in Form View and the other in Data Sheet View. I wanted the currently selected record in one view to also be the currently selected record when I tabbed over to the other view.
I set the Record Source of my main form to a query of my tables primary key. Then I entered the Primary key into the Master/Child link fields for both of my sub forms. But when I tab over to Data Sheet view, only the record that was selected in form view is displayed. I wanted Data Sheet view to display all of the records and simply to set the focus on the record that I was looking at in Form View. Is this possible without some extensive coding?
Answer Greg,
The DataSheet view needs to have the Master Child link fields de-linked, then you will need to use the main-form 'Current' event (ie. when a new record is selected).
In the code snippet, use the RecordSetClone property of the datasheet sub-form and match the MainForm PK value with the RecordSetClone PK value, then refresh the datasheet sub-form.
I believe there is an example on onboard help - look-up RecordSetClone
