Auto Selecting Sub Data Sheets

[aheath15]

My Situation:

I have a list of products, some of which contain sub-assemblies, which are
then listed in sub-data sheets. For ordering purporses, a user can go down
the table and select which products are needed (using a boolean field).
Since some products contain sub-assemblies, I am trying to figure out the
best way to have these sub-assembly components automatically selected to
prevent the user from forgetting to order necessary products.

I have been brainstorming ways to use queries/filters/etc, but have not been
able to get this to work properly. Any suggestions? If so, it would be
extremely helpful to explicitly let me know the 'terminology' of what's
needed, as that has been my main problem thus far.

Thanks!

 

[Danny J. Lesandrini]

This is really, really kludgy, but here's how I accomplished that.
You have to make sure the cursor is in the right cell, and then
you issue the Shift + DOWN command using SendKeys.

Me.WorkProgramID.SetFocus
SendKeys "^+{DOWN}"

Where you put this code will depend on what you're doing. I have
it in the AfterInsert() of the record for the same reason you gave,
because I want it as a reminder that there are sub records to enter.