Karl/Dirk - My bad. I just double-checked, and I did have a default value in
the table after all. I had been checking the wrong table. You pointed me in
the right direction though. It works as expected after I removed the default
value.

Thanks again for looking into it.

"KARL DEWEY" wrote:

These are formatted as text with an input mask of 000.
Where is the mask applied?

If you insert a value in the bound table field does the combo show the
correct corresponding information? Such as 8 then it show 410 Flash Card
Kit?


--
Build a little, test a little.


"bicyclops" wrote:

Samples:
PartPrefixID Part Type (Prefix) Prefix Description
1 001 CAD
2 400 Assembly
3 500 High-Level Assembly
4 998 Unknown
5 011 IC, Through Hole, Programmed
6 260 Stencil
7 350 Misc. Assembly
8 410 Flash Card Kit
9 411 EPROM Kit
10 999 Generics

The data types are Autonumber, Text & Text


"Dirk Goldgar" wrote:

"bicyclops" wrote in message
...
Dirk - answers below.

Row Source:
SELECT TblPartPrefix.PartPrefixID, TblPartPrefix.PartPrefix,
TblPartPrefix.[Prefix Description] FROM TblPartPrefix ORDER BY
TblPartPrefix.PartPrefix;

Bound Column:1
Control Source: PartPrefixID
Default Value: blank
Column Count: 3
column Widths: 0";0.5";2"
Format: blank

Thanks for looking into it!

Could you give me a few sample rows from TblPartPrefix? There aren't any
rows with the same PartPrefixID, are there? What type of data are
PartPrefixID and [Prefix Description]?

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)