MS Access Update Query help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayne - 30 Sep 2004 15:59 GMT

I've created a form that has many option boxes to help users choose
items (I need option boxes vs. combo boxes because they can choose
multiple items per category).

I've created an update query to change the value from 1 (system
automatically generates that) to the actual value I want. In the
criteria section of the append query, I put a simple if statement:
IIf("-1","London",""). Regardless of the value that is found however,
the query changes the 1 to the true' condition.

Can someone please help?

Reply to this Message

Brendan Reynolds - 30 Sep 2004 16:19 GMT

I'm not quite clear whether your expression is supposed to be looking at the
value of a form control or at a field in a table, but it is actually not
doing either one of those things, it's just looking at the literal value
"-1". It needs to be something like IIf(Forms!FormName!ControlName = -1,
"London", "") or IIf([FieldName] = -1, "London", "")

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

> I've created a form that has many option boxes to help users choose
> items (I need option boxes vs. combo boxes because they can choose
[quoted text clipped - 7 lines]
>
> Can someone please help?

Reply to this Message