I have a database which uses 1 form to input/edit records and another form to view them (no edits can b made to it).
The form used to view the records (form2) has a button on it called edit which when clicked on opens the other form (form1) so that the record can b edited.
The problem i am having is that both forms access the same data exactly the same way and both of them contain a subdatasheet.
When running the database and clicking on the edit button on form2 to open form1 to edit a record it says u cant open the subdatasheet as it is already opened - it then opens form2 but without the subdatasheet.
Is there a way to get around this, mayb by setting the edit button to close form2 b4 it opens form1.
Ifso how wud i do it?
The form used to view the records (form2) has a button on it called edit which when clicked on opens the other form (form1) so that the record can b edited.
The problem i am having is that both forms access the same data exactly the same way and both of them contain a subdatasheet.
When running the database and clicking on the edit button on form2 to open form1 to edit a record it says u cant open the subdatasheet as it is already opened - it then opens form2 but without the subdatasheet.
Is there a way to get around this, mayb by setting the edit button to close form2 b4 it opens form1.
Ifso how wud i do it?
