Hi All,
i have a for which is in focus
the query looks at a few records and scenarios but when i run the query i get and error that i can not find the value of 2 record
i just re entered the criteria but still same error
Form
Query:
# UPDATE [SB TBL History Qry] SET [SB TBL History Qry].[Select] = True
WHERE ((([SB TBL History Qry].[Select])=False) AND (([SB TBL History Qry].SBNo)=[Forms]![SB TBL History]![Select SB TBL History].[Form]![SBNo]) AND (([SB TBL History Qry].Updated)=False) AND (([SB TBL History Qry].[Applicable to AHZA])=True)) OR ((([SB TBL History Qry].[Select])=False) AND (([SB TBL History Qry].Updated)=False) AND (([SB TBL History Qry].[Applicable to AHZA])=True) AND (([SB TBL History Qry].SB_Attachment)=[Forms]![SB TBL History]![Select SB TBL History].[Form]![Attachment]));#
i have a for which is in focus
the query looks at a few records and scenarios but when i run the query i get and error that i can not find the value of 2 record
i just re entered the criteria but still same error
Form
Query:
# UPDATE [SB TBL History Qry] SET [SB TBL History Qry].[Select] = True
WHERE ((([SB TBL History Qry].[Select])=False) AND (([SB TBL History Qry].SBNo)=[Forms]![SB TBL History]![Select SB TBL History].[Form]![SBNo]) AND (([SB TBL History Qry].Updated)=False) AND (([SB TBL History Qry].[Applicable to AHZA])=True)) OR ((([SB TBL History Qry].[Select])=False) AND (([SB TBL History Qry].Updated)=False) AND (([SB TBL History Qry].[Applicable to AHZA])=True) AND (([SB TBL History Qry].SB_Attachment)=[Forms]![SB TBL History]![Select SB TBL History].[Form]![Attachment]));#