Populating a list box in Access 97

  • Thread starter Thread starter Thakur8385
  • Start date Start date
T

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..
 
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()
 
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
 
Can you help me with some sample code

Jeff Boyce said:
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
Click to expand...
 
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
 
Back
Top