Error 2950 - not looking up ID

[fayjohn111]

Hi All,

Scenario: box pops up, i enter someone's ID, it pulls all relevant info pertaining that ID.


I am currently receiving an error on this macro.


Error: 2950
Action Name: OpenQuery
Arguments: CD Pending Details_KDG, Datasheet, Edit

My question is i know the issue is coming from "CD Pending Details_KDG", however I don't know how to trouble shoot it since I am not familiar with "datasheet,edit"

If I had to guess, I am sure it means for me to edit something in "CD Pending Details_KDG"....any suggestion as to how I can trouble shoot ?

Feel free to explain it to me like a 5 yr old as i am not too familiar with Access, more of an excel type of guy.:banghead:

Thanks.

 

[Frothingslosh]

What is the exact error message you're receiving? Pretty much no one outside Microsoft has the error messages memorized by number.

If that IS the error message, then what we'd need is a writeup of the macro. (I'd say image, but you need 9 more posts before you can do that.)

 

[fayjohn111]

What is the exact error message you're receiving? Pretty much no one outside Microsoft has the error messages memorized by number.

If that IS the error message, then what we'd need is a writeup of the macro. (I'd say image, but you need 9 more posts before you can do that.)

The Error Message is:
"This expression is typed incorrectly, or is too complex to be evaluated.. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts o the expression to variables".

I have check the table in which it is searching and following the scenario as I enter the persons ID....the ID is correct...i went to the actual "CD Pending Detail_KDG" table it shows up if i do a manual search.