What do I use to place a list of people on a Access Report and given the choice to select one name from the list?
Also, Can I place an automated signature on a Access Report tied to a table?
What do I use to place a list of people on a Access Report and given the choice to select one name from the list?
Also, Can I place an automated signature on a Access Report tied to a table?
Reports are not intended to be interactive. However, in ReportView a listbox (not a combobox) can be clicked on and value returned. What do you want to happen?
What do you mean by 'signature' - a graphic of actual handwriting?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
A command button in a report's detail section knows which record that button is on when you click it. So you can get a name if that is part of the record, but if you take this route, you'd best consider the possibility that there is no name in some of the records. To me, the view looks kind of silly, and presents buttons on reports that maybe people start clicking out of curiosity. Why not just present the data in a form, which is supposed to be interactive?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I prefer to use a form to collect the criteria to be used to select the records for the report. This keeps the report simple. I also design my forms to be generic. This allows them to be shared with other reports.
Here are some examples you can use:
Report Dialog Examples