Happy to help.
Happy to help.
Just ran into another problem - I tried this on one form/subform group and it works flawlessly. I copied the report to use on another form/subform group and it doesnt. It will bring up the report fine if no filters are selected, but when you try to select filters and create the report it always promts you to enter a parameter value for what you had in your filter. Here is my code for the button that creates the report...
Private Sub print_unbound_Click()
DoCmd.OpenReport "tbl_Lots", acViewPreview, , Forms!frm_Parts_Dataview_Unbound.frm_Parts_Spreads heet_Unbound.Form.Filter
End Sub
The parameter prompt is Access telling you it can't find something. What does the prompt say exactly? Are all the fields in the filter present in the report?
the prompt says "frm_Parts_Spreadsheet_Unbound.ChipNumber" and has an input field, an ok button and a cancel button. The report does have a ChipNumber field, which is labeled the same as it is in the subform, which is what I dont understand
Add this line before that one:
Debug.Print Forms!frm_Parts_Dataview_Unbound.frm_Parts_Spreads heet_Unbound.Form.Filter
and see what the filter looks like. More here if you're unfamiliar:
BaldyWeb-Immediate window