How to create a button to open up records in a datasheet by double clicking?

[Kelly Warden]

I have a rather complex form with a listbox. I would like to be able to highlight a record and view in dataform. Unless there is a way to make the listbox look like the datasheet. The way it comes back now is all together. I would need a scroll bar.

Any suggestions?

[NeoPa]

Does Cascaded Form Filtering help.

Once you select the required record you can use the WhereCondition parameter to filter the form displaying the records.