Hi all
I have a continuous form that brings up a list of records from a search. When I double click anywhere on the record I require to view I want it to open a form containing all its details.
each record conatins a unique record number which I am picking up using ' me!... '
The way I have currently tried is as so,
Adding a double click expression onto the details section of the form. on the double click it picks up the record number from the current selected record and then opens the form. This works for the top record as it is the selected record. My problem is that is I click on any other record it doesnt work because the record is no being selected it is remaining on the top one. I think this is because there are no enabled controls on the form, and I dont want any enabled controls. Is there a way I can make the record select the one my mouse is over or the one I am clicking on without having to have enabled controls?
Many thanks for any help and advice given, it is greatly appreciated.
Thanks
Tim
I have a continuous form that brings up a list of records from a search. When I double click anywhere on the record I require to view I want it to open a form containing all its details.
each record conatins a unique record number which I am picking up using ' me!... '
The way I have currently tried is as so,
Adding a double click expression onto the details section of the form. on the double click it picks up the record number from the current selected record and then opens the form. This works for the top record as it is the selected record. My problem is that is I click on any other record it doesnt work because the record is no being selected it is remaining on the top one. I think this is because there are no enabled controls on the form, and I dont want any enabled controls. Is there a way I can make the record select the one my mouse is over or the one I am clicking on without having to have enabled controls?
Many thanks for any help and advice given, it is greatly appreciated.
Thanks
Tim