I have a form with a button that opens a 2nd form. The 2nd form has related records based on the 1st form's current record. When adding a record in form 1 and clicking the button which with the record is in the detail section (continuous) I get an error on the 2nd form when adding a record. I know it's because the 1st form's record has not been saved (referential integrity is on for this relationship)
My question is:
1.) What is the best way to save a record on the 1st form prior to opening the 2nd? onlost focus? Ondeactivate?
2.) Can I use the Menu Command saverecord in a macro? What is the best event to attached to?
3.) Info for ondirty says it only saves a record if it has been changed. Is a new record that has not yet been saved considered a "changed" record?