I have a datasheet subform that is powered by a non updatable recordset. I can't seem to design the recordset's query in a way to where it will be updatable -
Is there a way around this?
What I would like to do is have a user double click on a row in the (subform) datasheet and have it open so that it can be edited.
Is it possible to create a new (editable) recordset based on the row that is double clicked? If so, how would I do that?
-OR if anyone has a suggestion as to how best to pull this off, please let me know.
Thanks,
PDUNCAN
Memphis, TN - USA
Is there a way around this?
What I would like to do is have a user double click on a row in the (subform) datasheet and have it open so that it can be edited.
Is it possible to create a new (editable) recordset based on the row that is double clicked? If so, how would I do that?
-OR if anyone has a suggestion as to how best to pull this off, please let me know.
Thanks,
PDUNCAN
Memphis, TN - USA