Creating Report from filtered form

[Guest]

I have a form based on a table that has a command button to create a report
after a filter is applied. The command button executes the following code:
DoCmd.OpenReport "rptMovies7", acViewPreview, , Me.Filter
It does not work consistently. In particular there are 2 text boxes in the
form based on text fields in the table. The only difference between the text
fields is that one is the primary key so it is “requiredâ€. When I filter on
the primary key field (either using the filter by form or doing a “right
click†and “filter forâ€, the button works fine and creates a report based on
the filter. When I try to do the same on the other text field, the filter
works fine but when I click on the button I get a message box to “Enter a
Parameter Value†for “tblWork.txtCommentâ€. (The field name is txtComment in
Table tblWork).

Also, the form has a combo box to enter an attribute, selected from an
attribute table (the primary key of the attribute is stored in the main
table). If I do a “filter by form†and select an attribute in the combo
box, the filter works fine, but when I click the command button I get a
message box saying “Enter A Parameter Value†for “Lookup_cboAttrib1.Typeâ€.

Any ideas as to where to look? Is there a Form property that may not be set
properly?

Thanks in advance, Gsarry Gross

 

[Guest]

Hi Garry,

You might want to try Access MVP Armen Stein's report selection example:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________