Error creating a form with wizard

[llively2]

I get this error when using the wizard to create a form from an
exsisting table.

Compile Error. In query expression
'IIF(IsNumeric(tblStyles.StyleName), appload string
(tblStyles.StyleName), tblStyles.StyleName)'.

What must be done to correct this error?

Thanks again in advance,

Lynn

 

[Brendan Reynolds]

What is "appload string"?

 

[Jeff Boyce]

Not much context to go on, no idea what your variable names are, etc.

IsNumeric(tblStyles.StyleName) seems to be checking what may be a "name"
field for a number -- is that really what you want to be doing?

"appload string" is not defined -- is this a variable name? If so, it needs
square brackets ([]) around it.

The syntax for your IIF() statement seems a bit off -- check Access HELP for
correct syntax/usage.

 

[TC]

IIF (IsNumeric(tblStyles.StyleName),
appload string (tblStyles.StyleName),
tblStyles.StyleName)

There's no way "appload string" can be correct syntax, there. Sure you
haven't missed a dot in the middle?

HTH,
TC

 

[llively2]

Yes you are correct it is incorrect.

it is "apploadstring" no (.) no space

This is in a POPUP after:

Create form using wizard

Table/Queries (select) tblCaseWorkers

Selected all fields in table:
ID (primaryKey AutoNumber)
Name
Agency (all blank)
Address1 (all blank)
Address2 (all blank)
City (lookup from tblCity)
St (lookup from tblStates)
Zip (lookup from tblZip)
Phone (all blank)
Ext (all blank)

Next to "Justified"

Next (brings up following errors)

Form Wizard (POPUP)
! Compile Error. In query expression
'IIF(IsNumeric(tblStyles.StyleName), apploadstring
(tblStyles.StyleName), tblStyles.StyleName)'.

OK

Form Wizard (POPUP)
! Compile Error. In query expression
'IIF(IsNumeric(tblStyles.StyleName), apploadstring
(tblStyles.StyleName), tblStyles.StyleName)'.

OK

Form Wizard (POPUP)
! "Invalid us of Null"

 

[llively2]

Next step asks "What style would you like" and the area to the right is
BLANK of styles.

Form Wizard (POPUP)
! "The wizard was unable to create your form"

It appears to me the style templates may be missing???????

 

[llively2]

Corrections to above apploadstring = AppLoadString

! "Invalid us of Null" = ! "Invalid use of Null"