Search results

I don't know a lot about syntax but wonder whether the logic of 'AND' should be 'OR' because the ID for a single record cannot simultaneously =Text1 and =Text2.

So this syntax is working in terms of selecting the right ID & the right year: [ID]=[Forms]![frm Jumping Frog]![id] And [dot_year]=Format([Forms]![frm Jumping Frog]![Session Date],"yyyy") I have locked the id & dot_year but the problem now is that for a year that does not already exist in the...

Galaxion, thank you for your response. Some more questions for you if you don't mind: Where do I access debug.print? When I substitute variable names in the syntax you provided, i.e. ="[ID]=" & Me.[ID] " AND [Dot_Year]=" & Format(Me.[Session Date],"/#mm\/dd\/yyyy\#") ... I got the message The...

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.