Select Case Statement (A97 in NT)

[Brigitte P]

How do I refer to another form in a Select Case Statement.
I have Forms!frmUSUpdate.txtUnit, but this doesn't work.
The form I want to refer to is frmUSUpdate, the variable
is txtUnit. txtUnit has the values of "1W" "2W" "3W" etc.
Do I need to also refer to the form when I do Case "1W"
etc, and how should that syntax look in case I have to do
this.
Your help is appreciated.
Brigitte P.

 

[Brigitte P]

Thanks. I think I fixed it; probably just a typo.
Brigitte P.