Access 2000 Report Formatting

ok, i do not mean to not give you an entire easy answer but bear with me...
do you have Word available on the purchasing agents computer?
i would look at the solution this way: have Word create a 'mail merge' letter using a query as it's database.set up the query to filter for all the true conditions you want...plus any other fields you want to appear on the letter...
how does this sound? do you know how to build the query with the info you want? do you know how to make Word do a mail mergeletter based on the results of that query? if you get that far, we can figure out how to 'integrate' it or 'automate' it into the process...
just 2 cents...

Not all of the computers this is going to be installed onto will have Word because some of them will be salesmen out in the field that are almost completely coumputer illiterate. I would prefer to try to just use the Access Report feature included in the program itself. Also, I do not know how to do the Word Mail Merge... like I said, I'm a newbie! Also, I do not know how to build the query. I will explain what's going on so that maybe you will understand and be able to help me some more. This entire thing is built upon the Order Entry template included with Access 2000 with some changes here and there, mostly adding fields and functions, along with several new forms and tables. I made a copy of the Orders form, added some fields to the sub-form table, and then the new fields onto the sub form in the new Purchasing Form. So, some of the fields on the Purchasing Sub-Form are automatically filled in from the Order Form, and others are filled in by the purchasing agent. Also on this PO sub-form is a check box, that if true, will include that item on the PO Letter. If the check box is false, then the item should not be added to the letter. If you need more info, please let me know.
Thanks
admin@mindinthesky.com

Rather than a pop-up, I suggest a space on the form. When the user presses a button the event code includes something like
if CheckboxA=true _
then
param.BigText=me.BigText
docmd.openreport "StrangeLetter",,"CustomerID=" & me.CustomerID
endif

In the open event code for the report the infomration from the parameter, a public variable, probably in a code module, gets transferred thus:
me.BigText.caption=param.BigText
where the BigText control on the report is a label, not a text box.

"One of the fields in the form is a true/false checkbox. If the box is checked true, then a PO Letter needs to be generated which would include the suppliers name, address, etc. (The supplier is selected on the same form by using a combo box.)"

This can be handled by creating a macro that gets executed and has a condition on the line where the PO "report" is created.

"The report/PO Letter also needs to continue looking at the form for additional true conditions and include those items on the same PO Letter."
I am not entirely sure what you mean by this. Are you saying that there are other fields that may or may not need to be included but which are filled out or that, if the box is _not_ checked then the fields _won'T be filled outand therefore _shouldn't_ be included on the PO/report?

"Also, before the preview of this report oens, I need a pop up bow to prompt the purchasing agent for any additional comments he would like to include in the PO Letter. Can anyone please help me in writing the code for this function? "

It sounds to me like you need to have a "Create PO" button on the form (which could be enabled if a box is checked our could, in effect, replace the PO checkbox). This button would result in the "Additional Comments" form being displayed and then, when the User closes that form (or, optionally, clicks the "OK" instead of the "Cancel button on that form), the PO is generated as indicated previously.

If you would like to send along a screen shotof the form in question, i could probably be of more assistance.