LeeHutchins
New member
- Local time
- Today, 05:37
- Joined
- Nov 3, 2020
- Messages
- 13
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"
how can i do this?
thanks in advance
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"
Code:
DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> Won"
how can i do this?
thanks in advance