Hello all,
I am really hoping that you guys can help with a problem.
I have a mainform (frmMain Menu) which also has a sub form on it (frmSub). The subform is in datasheet veiw, and shows information from the main table.
I want to be able to double click on a record/cell (WIP), and for that to then open another form (frmAutoOpen) with the data from that record.
I have been able to set the double click property on the cell, so that it opens the form and displays the first record, but not yet been able to get it to display the record that has been clicked.
I have looked through another thread on here, and looked at the fixed DB that was uploaded. I have copied the code, and the hidden button behine the cell, but i cant get it to work. (It wont let me post the link)!
Any tips or pointers would be fantastic!
Matt
I am really hoping that you guys can help with a problem.
I have a mainform (frmMain Menu) which also has a sub form on it (frmSub). The subform is in datasheet veiw, and shows information from the main table.
I want to be able to double click on a record/cell (WIP), and for that to then open another form (frmAutoOpen) with the data from that record.
I have been able to set the double click property on the cell, so that it opens the form and displays the first record, but not yet been able to get it to display the record that has been clicked.
I have looked through another thread on here, and looked at the fixed DB that was uploaded. I have copied the code, and the hidden button behine the cell, but i cant get it to work. (It wont let me post the link)!
Any tips or pointers would be fantastic!
Matt
