Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I have a query that retrieves some data from Access database (I get ID, ItemName). I then want to use the data (ItemName) as a source for a drop down list. For this I use: Do While Not rsData.EOF ' Load the dropdown with the recordset values. ddCustomers.AddItem rsData.Fields(1).Value rsData.MoveNext Loop The only problem is when I want to use an item from the list to save it back to the database. Because items in the list box are not distinct (unique) I don't know how to identify them. Can I add items to list boxes with they ID's? Or do I have to relay on the item position in a list box. I would also be thankful if someone could please recommend some good site on this issue, ie recordset manipulation, binding recordsets with list boxes, dropdown lists, etc. Kind regards IgorM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
dropdown list contains 5 items want to add 100 how | Excel Discussion (Misc queries) | |||
dropdown list contains 5 items want to add 100 how | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
How can I set up to chose more than 1 item from a dropdown list (. | Excel Discussion (Misc queries) |