Search

[Guest]

I use VB to output a list of reports to a listbox embedded on a form.
However is there a way I can change the names that are displayed?
Eg. Actual report name displayed “Invoicerpt†Desired name “Invoice Reportâ€
I just want to use a more user friendly report name.

Also upon selecting a report in the listbox is there a way I can add custom
search fields for each report?
Example. If I click “invoiverpt†I would want lets say a search by invoice #
field to show up or if I click “jobordersrpt†I would want a search startdate
and search enddate fields to show up.

I think I just need a way to associate each report in the listbox with the
different search fields.

Can anyone help?

 

[Arvin Meyer [MVP]]

The usual way to do this is to have a table of report names and friendly
names. Use a list box or combo box to load the columns into the control's
rowsource property. Bind the control to the actual name column and set the
width to zero (0) so that click on the friendly name will load the report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks very much but is there any way I get a little assistance to actually
do what you said?

 

[Arvin Meyer [MVP]]

What kind of assistance do you require?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access