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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top