Search results

Thanks to everyone who helped, But I finally figured it out using only macros and queries. Now the entire program works like I want it to. Thank you all

Thanks, That did do something different, Now when I click it, A dialog box opens that says now printing, and a second dialog box opens that says "Enter Parameter Value". I don't understand. I didn't tell it to print, And INPUT should have given it its parameter value. ??? I'm getting more confused

Ok, I feel this is probably a simple fix and I'm looking to far into it. I have a OpenReport macro with arguments: Report Name - Information Report View - Print Preview Filter Name - Query2 Where Condition - [Incident Number] = [Forms]![New Incident]![INPUT] ( with INPUT being a text box control...

Docmd.OpenReport "Information Report",,,"Incident Number = " & me.INPUT Docmd.OpenReport "Information Report",,,"Incident Number = '" & me.INPUT & "'" This is what Ive got, not sure it helps, Also I do have a query with all fields but not sure what to put in the criteria field, nothing seems to...

I can't seem to get it to work, this can't be this hard. I copied and pasted the line from your link (with the extra "'" and without) what am I doing wrong, I would post pictures but apparently I am to New to the forum

I guess I also should have stated that If I am working on a record that all forms and tables share incident number "XYZ123" Then I only want the reports that show "XYZ123"

I have four forms named [Information Form], [Evidence Form], [Subject Form], and [Vehicle Form]. The Final Form is a Tabbed Form named [New Incident]. The tabbed form has four tabs, with each tab displaying one of the forms above. I also have a Print Command Button named [Print All] underneath...