Access 2002 look-up table is not displaying all data on pull down

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have created a look-up table to show company names. When pulling down the
list, about half of the names that are entered on the table do not appear.
Why? How can I get around it?

Thanks a lot!

Jose.
 
Have created a look-up table to show company names. When pulling down the
list, about half of the names that are entered on the table do not appear.
Why? How can I get around it?
Click to expand...

Well, there's something wrong with your pulldown.

Care to give us some more details? What's the Combo Box's RowSource?
How many companies (a Combo is limited to an absurdly large 65536
rows)? Any other details?

John W. Vinson[MVP]
 
When I created the master table, a field was defined as a look up table and I
selected that I wanted to read the data from another table called company.
That table for now only has 16 entries and when I pull it on the form, only 7
comes out. I am using no VB at all, just a simple Access table/form/report
creation.

Thanks for your help, John!

Jose.
 
Back
Top