I want to create some form of drop down list but pre fill the options.

Once the user makes their selection the drop down list should retract leaving only the selected option visible. It will probably need to also be scrollable
What should I use and how do I pre fill it?

Thanks
smiler44

You use a Combo Box or List Box.

Try your Access Help (F1) searching on both of these.

Read the explaination and post questions where required.

There are also Wizards available in Access to create these for you. F1 again shold have some stories on this.

As to the List... It can be a Table, a Query from one or more tables or a list of options you supply when creating or editing the Combo Box or List Box.

Hi PNGBill,
I have added a combobox and in the list property I have added a list of items but after each item I have to put a comma. The comma however appears after each item in the combo box. my lis looks like this

A,
B,
C,

what can I do to get rid of the comma, at the moment if i remove it the a b etc become corrupted.

thanks smiler44

Try "A";"B";"C"