J joe90 Registered User. Local time Today, 23:42 Joined Apr 15, 2008 Messages 23 Aug 4, 2009 #1 Hi, Kindest thanks in advance for any help you can give. I am trying to display the results of a query in a report that depends on a value I have entered into a form. Any help is muh appreciated Jo x
Hi, Kindest thanks in advance for any help you can give. I am trying to display the results of a query in a report that depends on a value I have entered into a form. Any help is muh appreciated Jo x
G Galaxiom Super Moderator Staff member Local time Tomorrow, 08:42 Joined Jan 20, 2009 Messages 12,895 Aug 5, 2009 #2 Add the condition to the criteria of the Record Source query of the report. eg: If it is to be equal to a field then enter the control name in the criteria line of the field being tested in the query like this. Forms!formname.controlname
Add the condition to the criteria of the Record Source query of the report. eg: If it is to be equal to a field then enter the control name in the criteria line of the field being tested in the query like this. Forms!formname.controlname