MS Access takes umbrage with the following piece of code, returning the runtime error 424:
If Me.Analyze_Product Is Not Null Then
DoCmd.OpenQuery "qu_count_product", acViewNormal
It points to the If statement to indicate the problem is there. I'm not sure what's wrong with the statement--the Analyze_Product field is a valid field... The problem seems to be with the "Is Not Null" part. if I change it from Is Not Null to = "whatever" then it works fine. problem is, i want to run the query only if the field value is not null, and i can't seem to find a way to get that to work...