If you are setting an ADO control's recordsource in runtime, can you have multiple where conditions?

eg.
If a database has two tables:
Forms (containing Title, Author, UpdateCode) and
UpdateDetails (containing UpdateCode, Surname)

Could you have a statement
"Select.... WHERE Forms.UpdateCode = UpdateDetails.UpdateCode, AND (TITLE = 'Quality Form' OR Surname = 'Bloggs')"

Is this possible and if so, what is the syntax to set the recordset??????