Compile error while creating a form with the wizard

[Shawn]

I'm getting: comile error. in query expression 'IIF(Isnumeric(tblstyles.Style
Name),Apploadstring(tblstyles.Style Name),tblstyles.Style Name)'

This happens while using the form wizard to create a PivotTable form. I can
OK through but the style list comes up blank.

Is there something incorrectly/not installed?

Shawn

 

[John Vinson]

I'm getting: comile error. in query expression 'IIF(Isnumeric(tblstyles.Style
Name),Apploadstring(tblstyles.Style Name),tblstyles.Style Name)'

This happens while using the form wizard to create a PivotTable form. I can
OK through but the style list comes up blank.

Is there something incorrectly/not installed?

There's something incorrectly TYPED.

Since your field names contain blanks, you must delimit them with
square brackets. Try

IIF(Isnumeric(tblstyles.[Style Name]), Apploadstring(tblstyles.[Style
Name]), tblstyles.[Style Name])

I'm assuming that you have a user defined function in a module named
Apploadstring.

John W. Vinson[MVP]

 

[Shawn]

I'm getting: comile error. in query expression 'IIF(Isnumeric(tblstyles.StyleName),Apploadstring(tblstyles.StyleName),tblstyles.StyleName)'

This happens while using the form wizard to create a PivotTable form. I can
OK through but the style list comes up blank.

Is there something incorrectly/not installed?

There's something incorrectly TYPED.

Since your field names contain blanks, you must delimit them with
square brackets. Try

IIF(Isnumeric(tblstyles.[Style Name]), Apploadstring(tblstyles.[Style
Name]), tblstyles.[Style Name])

I'm assuming that you have a user defined function in a module named
Apploadstring.

John W. Vinson[MVP]

John,

Thanks for the suggestion, but I do not have a user defined function, nor do
I use spaces in my field names. The spaces shown above are from a text editor
correcting my "mistakes." It should read:

'IIF(Isnumeric(tblstyles.StyleName),Apploadstring(tblstyles.StyleName),tblstyles.StyleName)'

This occurs as I am stepping through the form wizard, just prior to
selecting the "style" of the form. That is why I thought it must be something
installed incorrectly.

Shawn