ItemData and ListIndex property when using a recordset
Posted on 2007-10-16
I'm getting a little confused about retrieveing data from a recordset and loading it to a Access form. I'm able to get data successfully, but when I load the data to a cbo box, I'm using the ListIndex and ItemData improperly.
This is what I have:
.txtVendorNo = rstSearchResults!VendorNumber
.cboDistrict.ItemData(.cboDistrict.ListIndex) = rstSearchResults!DistrictID
.txtSubdivision = rstSearchResults!Subdivision
.dtpDatePaid = rstSearchResults!DatePaid
However, when I check out the data, the District is incorrect, using the value one higher...do I just use -1 somewhere? Or is there a proper way to do this?
Thanks for your help,