Control Records Displayed in a Subform

Control Records Displayed in Subform

Control Records Displayed in a Subform

Video 1 (5:18)

Klingest Asked — What I want to do is, that when you select a record in the subform showing “tblCalculation”, the related values from “tblSubCalculation” shall be displayed in the other subform. 

How can I do that?

In this video I answer Klingest’s question. I demonstrate how to capture the record selected (with VBA) in the first subform, extract the record’s ID, then insert the ID into an SQL Statement, again, with VBA Coding. Next I show how to insert the SQL Statement into the Recordsource of the Form contained in the subform. (Subform Window)… You can see in the YouTube Video that the second subform now displays the related records, the records that match the selected record ID number in the first subform…

The VBA code used in the video is available to buy:- Click on the button below:-

Video 1 (5:18)

Control Records Displayed in a Subform:-

… …

Leave a Comment