Access 2002 Variable If ... Then Condition

[chaddull]

I'm having trouble using a string variable as a condition in my If...Then statement. I have a concatenated variable which refers to an open recordset:

strAddNewCriteria = "rstDeliverable!" & strActFieldName & " <> 0 And rstDeliverable!booRequired = True And " & strClassCriteria

I try to execute an If...Then loop using strAddNewCriteria as the If criteria:

If Eval(strAddNewCriteria) Then

The application tells me that Access cannot find the rstDeliverable recordset. But, when I use the actual string (rather than the variable), the If...Then loop functions properly.

Does anyone have any suggestions?

Thank you very much.

 

[kbstoikop]

i dont know if microsoft fixed this but in access97 it doesnt like to evaluate expresions using true or false rather use "-1" for true and "0" for false.

 

[AbvAvgUser]

I am not entirely able to understand your problem here. Please clarify.

Secondly, from whatever I saw in your post, I feel there should be some syntax errors generated in code because there are some open quotes to which there are no corresponding close quotes