Hello,

Have a form which shows each record in an Access Database that has a lot of detail.

Then made an msflexgrid to show all the records in a grid fashion with less detail so the user can see the important stuff for all records at a glance.

Would like the user to be able to click on a row in the flexgrid and open the corresponding record which has the more detail and can edit etc. in the form.

Any suggestions on how to approach this?

Click on Msflexgrid row (anywhere)

open.Form1 with the same record as as the user clicked on the Msflexgrid.