Open form to specific record- using the where condition with multiple criteria

[cnew]

I'm trying to create an on click macro that will open a new multi item form to specific set of records. I would like to match [Student ID] fields on both forms AND apply a filter to include only the records that have 'Oral Qual' in [Committee Type], a short text field on the form I'm trying to open.

I've seen a few threads offering help with similar issues using Visual Basic, but I don't know VB. Is it possible to do this all within Access's macro builder tool?

If I set the where condition to: ="[Student ID]=" & "'" & [Student ID] & "'"
It will filter to the correct students. Likewise if I put [Committee Type]='Oral Qual' It will filter to those correct records. Logically, you would think I could join those with an AND, but I receive an error message that "The object doesn't contain the Automation object 'committee type'."

Is this possible to do in the macro builder, or do I need to take the plunge and dive into the code?

 

[isladogs]

In the end using code gives you more power & flexibility in terms of what you can do.
In this case try:

="[Student ID]='" & [Student ID] & "' AND [Committee Type]='Oral Qual'"

The key is getting the quotes correct

 

[cnew]

THANK YOU! I had probably tried every combination of quotes imaginable. (Except for that one apparently.)

I just started access two weeks ago and I've already learned so much. I'm sure before this project is through, I'll probably have to get into the code. I'm just trying to put it off as long as possible.