Lost Records when returning to Form A

[PDH]

I am building a library database to help our elementary school track their library books.

The BOOKS ENTRY form in my DB houses, well, books. I have a button next to the AUTHORS field within the BOOK ENTRY form. The button sends the user to the AUTHORS subform to add a new author, if needed. The only problem is, when you enter the new AUTHOR in that form and return to the BOOKS ENTRY form, the book record that was in the process of being added is lost.

Is there any way to leave the BOOK ENTRY form, add a new author, then return to the BOOK ENTRY form and finish out the record-in-progress without losing it?

 

[sillysod]

how about, dont use a subform, use another normal form.

the clicky button event should close the main form, taking the user to the author form.

when the original form closes it will save the part completed record.

now on the author field set a click button to "return to book entry" this will open a 3rd form called something "complete book entry" this 3rd form would be based off a query that would .... well

if say the author field was the 5th field you enter, then the user will have completed the first 4 fields before closing the part completed record to goto the author form.


so the criteria for first four fields would be "is not null" then everything after (and including) the author field would be set to "null" this would pull out the half completed record allowing user to continue.

alternativley the clicky that takes you from the add author screen to the form, could take you to a form that is based off a query that sorts results desending (either date or id number or something) therefore it would show the record that was entered (or part entered) most recently.

hope this gives you a nudge in the right direction