By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

MS Access Update Query help

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
"Wayne" <el************@cibc.com> wrote in message
news:f0**************************@posting.google.c om...
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?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.