Creating a combo box with 250 choices in list

  • Thread starter Thread starter John Zellmer
  • Start date Start date
J

John Zellmer

I want to create a combo box which correctly spells each
client name we deal with (250), so that the user can just
pick one and not enter it mispelled on their own. Is
there a way to import a column of names from an Excel
spreadsheet? Anything but having to type each one in.

Thanks,

John
 
You can link your Excel spreadsheet to Access using File|Get External
Data|Link. After linking, use the Excel sheet in a Make Table Query to
build your Access table of Customer Names.
 
Back
Top