invalid procedure call in query

[rdshag]

I have created two queries
query one "drawing list" has the drawing number and equations that beak the number into segments

example yyy-drw-xe-001 yyy drw xe 01

query two I have a table and drawing list query with the drawing numbers linked

when I bring an equation in from drawing "xe" I get invalid procedure call

can any one help

Duncan

 

[The_Doc_Man]

"Invalid Procedure Call" means that you have used a function in your query and didn't call it correctly. For an overly simple example, you could have a DMax(field, table, criteria) call in a query and have an error in one of the arguments.

If you are using DAO queries and the daoDB.Execute method, some substitutions will not work unless you build the string separately and then pass it as a monolithic item. That would do it.

If you aren't using SOME type of function somewhere in the query then ask this: Is the query based on an SQL Aggregate? That is a function, more or less, though it is hidden by syntax.

 

[rdshag]

I pick XE from the drawing list box and I make no changes to it

 

[The_Doc_Man]

I see that you re-posted with more details. If the other post was the same problem as this one, then obviously your issue was with mis-use of IIF.