Click To Select An Item On Table Form

[OneToLearn]

Hello - I have a table form that is base on a query, this form display a list of people's name and a few other information. What I'd like to do is to able to click on a name then perform another action on that person, for example to run another query or function. I do not know what this action is called to Google, please show how to perform this action, suggestion or link that I can look up or what is this action called.

Thanks in advance.

[pbaldy]

What action? Here's where to put code:

http://www.baldyweb.com/FirstVBA.htm

[Missinglinq]

You really haven't given us much to go on, i order to help you, but in a general way you'd use the DoubleClick event of the Control that holds the name in question, and possibly the Name, itself, or possibly the Primary Key, in a WHERE Clause, to pinpoint who it is you want to do this 'another query or function' against.

More exact information will allow us to help you, more exactly!

Linq ;0)>

[OneToLearn]

Thank you both for replying
I need to do the following:
I have a table form that show the following information base on a query:
Date Name OrderNumber NeedSpecialNotes
01/01/2013 John 1234 yes
01/01/2013 Mary 1235 yes
01/01/2013 Bil 1236 yes
What I need to be able to do is to click on a name, let's say John,
then an order report for John for that date is created, an e-mail is opened with the report attached.

[pbaldy]

To email a filtered report, you either have to open it filtered in Preview mode first:

BaldyWeb wherecondition

then email it, then close it, or have it filter itself:

Emailing a different report to each recipient

The simplest way to email a report is SendObject.