Populating a list box in Access 97

[Thakur8385]

Hi,
I am trying to modify an age old application that was created using Access
97.
Please help me populate a multi-column list box in access 97..

 

[Thakur8385]

Hi,
I am trying to modify an age old application that was created using Access
97.
Please help me populate a multi-column list box in access 97..

Access 97 doesnot have .additem()

 

[Jeff Boyce]

A more common approach to populating a listbox is to use a query against a
table. That way, you don't have any issues with items on a list ... the
items are all in a table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Thakur8385]

Can you help me with some sample code

A more common approach to populating a listbox is to use a query against a
table. That way, you don't have any issues with items on a list ... the
items are all in a table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

No code involved.

First, create a table that has the values you will use in your list.

Then create a query that returns those values from that table.

Finally, in a form, add a combobox bound to the field in which you want to
store the value, and make the row source for that combobox the query you
just created.

Regards

Jeff Boyce
Microsoft Office/Access MVP