Let say I have a form called "frmMachineSpecs" witht wo subforms,
"frmSpecs" and "frmMachines".
Both subforms are in datasheet view. The first control in "frmSpecs"
is "txtOEM_No".

I want to select a record in frmSpecs. Based on the OEM Number of the
record selected I want to display all the machines that use that spec
in the frmMachines subform.
How do I do this? I think I need to change the record source somehow.