Error in Query looking at Form Records (1 Viewer)

[Gismo]

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]));#

 

[theDBguy]

Hi. Are you getting an error message about multi value fields?

 

[Gismo]

Hi. Are you getting an error message about multi value fields?

yes

 

[Gismo]

yes

it was fine before, today i get this message and not sure why and not sure on how to fix this

View attachment 83531

View attachment 83532

 

[theDBguy]

yes

View attachment 83531

View attachment 83532

Did you verify the name of your subform control?

 

[Gismo]

Did you verify the name of your subform control?

yes

i change the name of the subform, seems to work for new

 

[Gismo]

i used the builder to create the 2 criteria so not sure why it did not like the name of the subform

 

[Gismo]

sorry, still not working

 

[theDBguy]

sorry, still not working

You may have to post a demo db.

 

[Gismo]

You may have to post a demo db.

This DB is massive with all the Tables linked to different back ends
not sure i will be able to send you the DB

i even deleted the sub form and re created it, still no luck

 

[Gismo]

i made a link to the 2 controls from the sub form on the main form and then ran the query only from the main form
for new it seems to be working fine

when i save, close the DB and open it again, i get the same error

 

[theDBguy]

i made a link to the 2 controls from the sub form on the main form and then ran the query only from the main form
for new it seems to be working fine

when i save, close the DB and open it again, i get the same error

Unfortunately, this makes it hard for us to troubleshoot without seeing it. Sorry.