vic_12

hi!!!!

could any one help me display my combobox.

i have 2 tables

1. namelist
- recordid
- fname
- lname
- religion

2. religion
-religionid
religion

1st there are data in the religion table. my form is connected to the first table with a combobox in religion which i want to show the select in the 2nd table. im using ADO and access. i have already made a relationship between the 2 tables(religion-religion)

thanks

TheDutch IceMan

Your relation should be religionID.

Do Until objRs.EOF
Me.lstReligion.AddItem objRs!religion
lstReligion.ItemData(lstReligion.NewIndex) = objRs!religionID
objRs.MoveNext
Loop

Now you can use the lstReligion.ItemData(lstReligion.NewIndex)
For example when the user clicks the list, the ItemData will be selected and perhaps added (after an insert or update statement) in the first table.