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?
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?
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.