Solved open form wiith criteria not equal "Won" (1 Viewer)

[LeeHutchins]

Hi,

im trying to open my form with a view of all records where [Tender Status] <> "Won" but with the below code it appears with a input box asking me to define "Won"

      DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> Won"

how can i do this?

thanks in advance

 

[Gasman]

Hi,

im trying to open my form with a view of all records where [Tender Status] <> "Won" but with the below code it appears with a input box asking me to define "Won"

      DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> Won"

how can i do this?

thanks in advance

Try

   DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> 'Won'"

 

[LeeHutchins]

Try

   DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> 'Won'"

Gosh i feel dumb, thank you !