[AccessD] Combo box not displaying 6 numbers

[Rocky Smolin]

Bill:

Like all projects the original description here was about 1/6th of what the
project actually turned out to be.  So my first pass on that form I used the
combo because the case table uses a PK so that combo box is bound to the PK
but displays the case number. There are other ways to do this - using a text
box for the value and a hidden text box for the PK, but this was expedient.
Just like the solution. :)

R
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Saturday, March 11, 2017 8:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo box not displaying 6 numbers

>>they know the case number that
they want to fill in there so they don't really need the list.

??

So why a combobox and not a textbox?

Is it to view other columns, or to look up the pk from the list index?

Just wondering why take the performance hit in querying and filling in a
combo box when all they really need to do is a short Dlookup  based on a
textbox entry in the on-exit of a textbox.


>From my non-flammable Note 3,
Bill Benson
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com