MS Access Update Query help

W

Wayne

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?
 
B

Brendan Reynolds

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", "")

--
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.
 
Top