Query based on selection in form (Datasheet view)

A

aalang

I would like to make a query based on a selecion (more than one
selection) in a subform in datasheet view.
the point is to be able to use this query as a base for sending email
to the selected posts, delete the selected posts or perfor other
functions.
 
O

Ofer Cohen

To refer to a text box in a sub form use

Forms![MainFormName]![SubFormControlName].Form![TextBoxName]

Replace the string with the proper names and you will be able to use it in a
query.
Put this line in the criteria section of the query
 
Top