|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 6th, 2010, 09:50 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Having a drop down combo box preceed the running of a report
Is it possible to have a combo drop down list of choices based on a field(s)
preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from? 
|
|
#2
January 6th, 2010, 10:24 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Having a drop down combo box preceed the running of a report
Sure this is possible. Use a combo box on a form for the user to first select
the record. Then provide a command button that opens the report using the value of the combo box as the criteria/filter. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Is it possible to have a combo drop down list of choices based on a field(s) preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from?
|
|
#3
January 7th, 2010, 02:53 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Having a drop down combo box preceed the running of a report
Of course! Hahaha thanks Duane. It sometimes just takes someone to state
the obvious! "Duane Hookom" wrote: Sure this is possible. Use a combo box on a form for the user to first select the record. Then provide a command button that opens the report using the value of the combo box as the criteria/filter. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Is it possible to have a combo drop down list of choices based on a field(s) preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from?
|
|
#4
January 7th, 2010, 03:14 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Having a drop down combo box preceed the running of a report
Actually I spoke too soon. I need the record to print to a specific report
format that I have created. I just want to be able to choose a particular record first and then have the report I created generate with that records information. "Duane Hookom" wrote: Sure this is possible. Use a combo box on a form for the user to first select the record. Then provide a command button that opens the report using the value of the combo box as the criteria/filter. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Is it possible to have a combo drop down list of choices based on a field(s) preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from?
|
|
#5
January 7th, 2010, 04:01 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Having a drop down combo box preceed the running of a report
Try something like this http://www.mvps.org/access/reports/rpt0002.htm.
-- Duane Hookom Microsoft Access MVP "Teeder" wrote: Actually I spoke too soon. I need the record to print to a specific report format that I have created. I just want to be able to choose a particular record first and then have the report I created generate with that records information. "Duane Hookom" wrote: Sure this is possible. Use a combo box on a form for the user to first select the record. Then provide a command button that opens the report using the value of the combo box as the criteria/filter. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Is it possible to have a combo drop down list of choices based on a field(s) preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from?
|
|
#6
January 8th, 2010, 05:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Having a drop down combo box preceed the running of a report
Thanks Duane! That did the trick.
"Duane Hookom" wrote: Try something like this http://www.mvps.org/access/reports/rpt0002.htm. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Actually I spoke too soon. I need the record to print to a specific report format that I have created. I just want to be able to choose a particular record first and then have the report I created generate with that records information. "Duane Hookom" wrote: Sure this is possible. Use a combo box on a form for the user to first select the record. Then provide a command button that opens the report using the value of the combo box as the criteria/filter. -- Duane Hookom Microsoft Access MVP "Teeder" wrote: Is it possible to have a combo drop down list of choices based on a field(s) preceed the generation of a report that allows the user to choose a specific record that a finished report is then generated from?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
