Switchboard won't cooperate

[anthony.carter]

Hi,

On attempting to first set up a switchboard (tools - database
utilities-switchboard manager)
the message 'There was an error compiling this function'.

Nevertheless 'Switchboard Items' is created in the tables section.

When the main switchboard is being edited it throws up an error
message : 'Compile error in query expression 'IIf(Is
Null([argument]),"",([argument]))'

When an attempt is made to put one of the forms on a switchboard the
error message displayed is, "You can't go to the specified record".

Can I really be doing this much wrong or does it stem from an earlier
error?

Cheers,

Regards,

TC

 

[strive4peace]

IsNull does not have a space

IsNull(something)

if something Is Null

~~~


also, to resolve this:
"You can't go to the specified record"

try saving the record before you move the record pointer

if you are in the code behind the form:

if me.dirty then me.dirty = false

I have also seen this error when combos or listboxes use the form
controls for criteria -- instead, construct the SQL and write the values


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[anthony.carter]

Thanks Crystal

 

[strive4peace]

you're welcome, anthony happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*