User determined report

  • Thread starter Thread starter Mark Gough
  • Start date Start date
M

Mark Gough

I want the user to be able to select a field from a listbox on a form which
will then tell a report what field to use. I have made a little pop up form
that asks the user to select a field from a table and that works fine but
how do I give the control on the report it's source?

Mark
 
I have the exact question. I have created a pop up form
to allow my users to select a company name from a list to
run a report on and can't get my form to work. I keep
getting a parameter prompt which requires the user to type
in the name instead, which could result in errors from
typos.
 
1) The form (frmMyForm) has to remain open while the report runs.
Probably the most straightforward way of managing this is for the
button that "dismisses" it after you have set your listbox
(lbxListbox) correctly to make the Form invisible (Me.Visible=False)
rather than closing it, and having the Report ultimately close it from
_its_ OnClose Event.

2) As long as the Form is open, the value of the listbox can them be
retrieved as Forms("frmMyForm").lbxListBox

I want the user to be able to select a field from a listbox on a form which
will then tell a report what field to use. I have made a little pop up form
that asks the user to select a field from a table and that works fine but
how do I give the control on the report it's source?

Mark
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top