Need help with update sql plus filter

[Clddleopard]

I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
[Forms]![OpeningForm]![Responsibility]
WHERE (((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility]
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility] And
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));

ApprovalStatusID is an integer
OtherStatusID is an integer

ListQry is the recordsource for my form. I would like to add the filter on
the form to the Where statement. I can't get it to work. I think I'm having
issues with the spaces and quotation marks and all that. Could I get help?

 

[S.Clark]

The UPDATE statement is used to update data in the table, so I don't
understand your objective.

 

[KARL DEWEY]

I can't get it to work.
What is it not doing? What is it doing it should not do?
Post examples of --
ListQry.ApprovalStatusID
[Forms]![OpeningForm]![Responsibility]
ListQry.OtherStatusID
-- where you say it does not work.
What 'spaces and quotation marks'?

--
Build a little, test a little.

I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
[Forms]![OpeningForm]![Responsibility]
WHERE (((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility]
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility] And
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));

ApprovalStatusID is an integer
OtherStatusID is an integer

ListQry is the recordsource for my form. I would like to add the filter on
the form to the Where statement. I can't get it to work. I think I'm having
issues with the spaces and quotation marks and all that. Could I get help?

 

[De Jager]

I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
[Forms]![OpeningForm]![Responsibility]
WHERE (((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility]
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(((ListQry.ApprovalStatusID)<[Forms]![OpeningForm]![Responsibility] And
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));

ApprovalStatusID is an integer
OtherStatusID is an integer

ListQry is the recordsource for my form. I would like to add the filter on
the form to the Where statement. I can't get it to work. I think I'm
having
issues with the spaces and quotation marks and all that. Could I get help?