A report based on a filter list 1

[humphreyoji]

I have designed a report that is based on a query with a field called LPONumber. When the report is clicked, I have to manually enter the desired LPONumber manually.

Can I ammend the report so that when I click on the report, a list of all the LPO's is displayed and then when I select an LPONumber from the list, it executes the report and shows me the details of that specific LPO number.

 

[Crowley16]

no...

but you can build a form which displays all the relevant numbers, and then from that from, you can initiate the report, with the selected number.

you can even have this form popup from an event in another form, and close itself when the report has been generated...

--------------------
Procrastinate Now!

 

[humphreyoji]

I like your solution. Next thing is how do I apply it.

 

[Crowley16]

build a form, on the form have a list box, in the listbox return all the ref numbers you want...

in the onClick event of the listbox, initiate the report...

in the underlying query of the report reference the listbox's value of this new form...

--------------------
Procrastinate Now!

 

[humphreyoji]

Thanks so far.

I have creates the form with the list box and I have created an event attached to the list box that initiates the report.

Where in the underlying query of the report do I referenc the list box value of the form ?

 

[Crowley16]

in your where statement...

syntax:
select ... from ... where forms!formName!controlName

--------------------
Procrastinate Now!

 

[humphreyoji]

Thanks. It worked perfectly. Bless you.

 

[humphreyoji]

I am using the "User Level security Wizard". The database is on a shared drive. However, the short cut to open the secure database is always placed on my desktop and when I copy it to the shared drive, it gives an error message.

Is there a way that I can force the shortcut to be created on the shared drive rather than on my desktop or how do I change the properties of the icon ?