Form Open - Implement new record.

B

Billp

Hi,

I have a form which when you use the "next previous record" navigation
buttons, has an on current which detects a new record and allows the user to
create a new entry. On Save

' If the user clicks the EditCustomerSave button (which is
' only visible in 'editting' view), then DON'T undo any changes.
' Changes are automatically saved, when you move off the record,
' so the subroutine doesn't actually have to do anything.
' Call the FlipEnabled procedure to revert to 'normal' view.

Call FlipEnabled(Me, cboCustomerID) 'called from module

This reverts the form to normal view with the the new record as part of the
whole as there is a bookmark from the previous record.

If I call this form up directly via,
DoCmd.OpenForm "frmCustomer_List", , , , acFormAdd

Any save using the existing control causes a crash as there is no bookmark
existing to the previous record.


What I would hope I can do is open the existing form and force the new
record event - like using the navigation buttons to prompt a new record,
which would make life really easy for everyone.
Can this be done?

With Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top