Multiple Listboxes

[Butterflies88]

Hi,

I have a form with several listboxes. i would like to select a row from any of the listbox and edit the details via a button which will open a form. How do u go about doing this?

[ibgreat]

Create a bound form based on the underlying table with the appropriate fields.

In your Button's OnClick event add the line:
DoCmd.OpenForm ("frmYourNewForm",,Me.Yourlistbox)

This should use the WHERE function in the OpenForm command to limit your result to only that record. I am assuming that the first column in your list box contains the primary key.

Sometimes my syntax is off as I don't do this all the time. Double check the syntax of OpenForm.