Boy, that has me stumped. Whenever I have had issues with the
Not-In-List combo box, I have had a comma or an apostrophe sneaking in.
Or the value was keyed in, and then the user has re-keyed the values in
the Add form. The new information was different from the information
that was keyed into the combo box.
For example: Combo Box data Entry = Smith, Karen
Form data Entry = Last Name: Smythe
First Name: Karen
Then when they get back to the Combo Box, they get the Not-In-List
message again. (You may want to watch the Open Args that come across
to see whether a space is coming along or not.)
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of allisonrja
Sent: Friday, October 14, 2005 8:15 PM
To: [email protected]
Subject: [AccessDevelopers] Re: combo box - not in list
Nope. The values are straight forward.
System assigned primary key, long name, short name, and registration
number. Nothing has a single quote, double quote, or any other unique
character. Straight forward numbers, letters, and spaces.
--- In [email protected], "Crosier, Dawn"
<[EMAIL PROTECTED]> wrote:
>
> Does the value contain any special characters? Comma's,
apostrophe's,
> etc.?
>
> Dawn Crosier
> Application Specialist
> "Education Lasts a Lifetime"
>
> This message was posted to a newsgroup. Please post replies and
> questions to the group so that others can learn as well.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/