how to create list,by pre filling (1 Viewer)

S

smiler44

Registered User.

Local time

Today, 20:06

Joined

Jul 15, 2008

Messages

641

• Sep 11, 2011

• #1

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

 

P

PNGBill

Win10 Office Pro 2016

Local time

Tomorrow, 07:06

Joined

Jul 15, 2008

Messages

2,271

• Sep 11, 2011

• #2

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.

 

S

smiler44

Registered User.

Local time

Today, 20:06

Joined

Jul 15, 2008

Messages

641

• Sep 11, 2011

• #3

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

 

P

PNGBill

Win10 Office Pro 2016

Local time

Tomorrow, 07:06

Joined

Jul 15, 2008

Messages

2,271

• Sep 11, 2011

• #4

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