Hello Richard,
In an old post you showed the following and said it should work!

Docmd.OpenForm "SomeFormF",,,"ID=" & ListBox & " AND SomeOtherVal=" & X

I have an AppointmentsListF (continuous form with User, IsOpen, and other fields).

I use a Login Form and pass openargs to the next menu form when I open my Main Menu.  Login Form takes me to Main Menu for the User that is logged on. On my Main menu I want to add My Open Appointments for the logged in user (lngUserID).  When I msgbox I get the correct userID showing.  I see all the appointments in the command to Open Appointments.

DoCmd.Openform "AppointmentsListF", acNormal,, "UserID = " & lngUserID shows me a list of all the Appointments (whether IsOpen is true or false).  

How do I get :
DoCmd.OpenForm "AppointmentListF", acNormal, , "[UserID] = " & lngUserID & " And [IsOpen]=" & "'Yes'"
to work?

I want to see just the Open Appointments for the logged in User from the AppointmentListF form!

Please help! Thank you!!