I am trying to reference the fields on the active record in a subform. What I would like to do is have the user select a row on a subform (Datasheet View) and have a drill thru query generated. How can I pass fields from the active record in a subform to a query using VBA? Any help is appreciated...