pls help : COMBO box or list box 
Author Message
 pls help : COMBO box or list box
hi there
i would apprieciate some help please, my problems are
1. i have a database from which i would like to chose a certain record
of a field, these recs should automatically be displayed in an combo
or list box. how do i do this

2. what should i use are combo or a list box, and what difference will
either make?

tia
Thanks In Advance From..
Irfaan Hamid
Kuala Lumpur,
Malaysia.



Mon, 23 Jul 2001 03:00:00 GMT
 pls help : COMBO box or list box

Quote:
>hi there
>i would apprieciate some help please, my problems are
>1. i have a database from which i would like to chose a certain record
>of a field, these recs should automatically be displayed in an combo
>or list box. how do i do this

This is in a Module that I have:
Public Sub LoadCallTypes(ListBoxName As Object)
        Set MyDB = Workspaces(0).OpenDatabase(App.Path + "\PDisp.mdb")
        Set MyTable = MyDB.OpenRecordset("CallType")  ' Open Recordset.
            Do Until MyTable.EOF    ' Do until end of file.
                    MyCall = MyTable.Fields("CallType")
                    ListBoxName.AddItem MyCall
                    MyTable.MoveNext    ' Move to next record.
                    Loop
End Sub

If you don't need to display all the records, you might want to try to using
"Find"

Quote:
>2. what should i use are combo or a list box, and what difference will
>either make?

I think that is going to be your personal preference, a combo box is used if
you only want (1) record to be viewed and selected, and a list box is used
if you want multiple records viewed and/or selected.


Mon, 23 Jul 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. List box /combo box usage in a DTS VB custom task

2. Application Role w/Access 2000 combo boxes, list boxes, reports

3. List Box and Combo box

4. adding to a combo box or list box

5. Populating a combo box from another combo box

6. Populate a combo box from another combo box selection

7. selecting records for 2nd combo box dependant on first combo box

8. HELP Forms, combo boxes, text boxes

9. Help filling second box from first combo box

10. Text Box (Combo Box) help

11. Newbie: Set a combo box style(2)/Dropdown list to the first element in the list

12. Newbie: Set a combo box style(2)/Dropdown list to the first element in the list


 
Powered by phpBB® Forum Software