[AccessD] combo box Limit to List question

Here's what I've found with just a little testing:

Access automatically updates the Limit To List setting from No, the default,
to Yes if the bound column isn't the first column or if the bound column is
the first column, but you render it invisible. Not only must the bound
column be visible to the user, it must be the first column in the control. 

Now, I might not have it exactly right as there may be more or less to it
all. But so far, that seems the gist of it. Now, when you consider all
that's going on, I can understand the limitation -- but it seems like one
that they'd have allowed for in some way. 

Susan H. 
 

Susan:

I'm just about to have this problem.  Combo box with a PK of AssetID in the
invisible column(0) and the asset bar code in column(1) - visible.  List is
limited to assets of a certain type but if the user enter a bar code of a
different type then I have to process it anyway.  Bound column is AssetID.

I'll be following this thread and I'll let you know if I find a way around
it.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message -----
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Sunday, June 06, 2004 7:43 AM
Subject: [AccessD] combo box Limit to List question


> Here's one I've never run across before -- you can't set the Limit to LIst
> property to No if the control's bound column isn't visible? Wow... that's
a
> nasty little catch that could really be a clean up mess if you weren't
> prepared for it. I've never run into it before. So, if you want an
> updateable list, you have to display the bound column instead of whatever
> data you really want to display... nasty. :(
>
> Susan H.
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com