Here is my non-working code for one of the command buttons, if anyone can tell me what is wrong...
Private Sub cmdPrevFULLandRET_Click()
DoCmd.OpenReport "repProposalActivity", acViewPreview, , "[project_type]= 'Full Proposal' Or 'Retention Exercise'"
End Sub
I have a list box that lists the three types of proposals I work on. When a type is selected, you can generate a report of only those types of proposals. The listbox is filled with a query of all proposal types.
I would like to generate a report based on two types of proposals. i.e A report...
I have two small (I hope) questions.
1- I have a listbox that lists client names. The listbox values are generated by a query. If you click on a client name, it generates an activity report for that client. If there are 'x' entries per client in the table, the client's name appears 'x' times...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.