>Hi there,
>
>I have a list box which displays three different fields(id,decription,request) i wanted to know when i double click on a record from the list box how i can retain the values of these three fields for that record so it can be used in the form which will pop up to add new entry. Thanx for the help
Bilal
IN the InteractiveChange() event of the listbox:
lnID = this.list( this.listindex, 1)
lcDesc = this.list( this.listindex, 2)
lcRequest = this.list( this.listindex, 3)
or better:
With this
lnID = .list( .listindex, 1)
lcDesc = .list( .listindex, 2)
lcRequest = .list( .listindex, 3)
EndWith
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.