Filtering

[ramdil]

Hi All.
I have a form which is directly bound to the table.I have a list box also in the same form which will show the entered data.Now i have a small problem.
If i double click on one row in a list box, i want the data populated in the textboxes above for the selected record in the listbox.Can any one help by giving me the code for this.I have a primary key field in listbox rows.Thanks in advance

[NeoPa]

You will need an event procedure to handle the double-click event of the ListBox control.
In there you set the Filter property of the form to the string formed from the selected line of the ListBox and the AllowFilters property to True. Next you call the Me.Requery to refresh the form.