Button navigation between Base forms?

[nigelmercier]

Is it possible to set up a button on a form that will save the contents and open another form? The second form would need a similar button to go back. In fact good design means that both forms would have both buttons, hopefully one showing as active.

[frofa]

Button navigation between Base forms has to be done with a macro which launches when a push-button on your form is clicked. Does this link help? Here is a movie tutorial that might also be useful.

[nigelmercier]

Yes, that helps a lot, thank you. I can now switch between forms using the following:

Sub OpenForm_1
const sNewDocumentName="Log Entry"
const sOldDocumentName="Maintenance Entry"
REM STORE? ThisDataBaseDocument.FormDocuments.getbyname(sOldDocumentName).store
ThisDataBaseDocument.FormDocuments.getbyname(sOldDocumentName).close
oNewFormDocument = ThisDataBaseDocument.FormDocuments.getbyname(sNewDocumentName).open
End Sub

Sub OpenForm_2
const sNewDocumentName="Maintenance Entry"
const sOldDocumentName="Log Entry"
REM  STORE? ThisDataBaseDocument.FormDocuments.getbyname(sOldDocumentName).store
ThisDataBaseDocument.FormDocuments.getbyname(sOldDocumentName).close
oNewFormDocument = ThisDataBaseDocument.FormDocuments.getbyname(sNewDocumentName).open
End Sub

I’m still working on how to make it save the contents of the form, although sometimes it does.

The second form uses part of the same table as the first (linked with PK ID from first table as FK in second 1:n). The main problem is that when I switch to the second form, there is no FK reference added for the current ID into the second table.