Is this possible?

I have a mshlexgrid that shows information from a recordset.

Is it possible, when the user double clicks on a particular record on the mshflexgrid, it can go into my other form and display the full details about that record?

i.e the mshflexgrid only provides selected information about a particular invoice. If i double click on it, it can go into my main form and show the full invoice via a procedure that i have called display (it shows the invoice).

I hope i have been clear.

Can this be done? if so how?

I have my unique field showing in the mshflexgrid (Invoice No). Can i somehow get that value from the mshflexgrid to then search through my database and show the full invoice?

absolutely...

Let's say your invoice# is in col 5

flexgrid.col = 0
form2.show

in the formload event...

sql = "select * from <table> where invoice = " & trim(form1.flexgrid.text)

Wat happens if my form2 is already open? would i place it into a module and link the module to the form2?

I managed to do it. I did use a module. Works a charm. I added it to my search procedure that i previously had.

Cheers for that.