Search results

I have a Where Condition in an OnClick Open Form that I want to change from: ="[ID]=" & [ID] to something with multiple criteria as in ="[ID]=" & [ID] AND "[Date]=" & [Date] This syntax isn't working in that it gives me the correct year but gives the same ID (1st in the table) no matter which ID...

Hi everyone, I've just joined the forum this afternoon. Have a question about the Where Condition of an OpenForm but I will save that for a more substantive thread. Working in a psych lab at the U of Nebraska. Hoping to come up to speed on Access (& VBA) over the next several weeks.