[AccessD] combo box Limit to List question

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