Navigate away from Form then back clears Form Data??

[KerryAustin]

I have a Form that is part of a Navigation Page with several forms. In form FormDelay I can enter information regarding procedural delay information. If a Team Member is not included in my cascading dropdown list I have a command button (+) Add Member that the user can click on that takes them to the Add Staff Member Form where they can enter information and onced saved is available in the dropdown. My problem is when the user returns to the FormDelay the data is cleared. I think this occurs because of my code which opens a new clean form when open.

Private Sub cmdNew_Click()
DoCmd.GoToRecord acActiveDataObject, , acNewRec
Call CarryOver(Me)
MyExit:
Exit Sub
MyErr:
If Err.Number <> 2105 Then
MsgBox Err.Description
End If
Resume MyExit
End Sub



I need to have code that if the form FormDelay is open and data has been initiated return to form with out opening new. I have included a view of my Form.

I also have this code in my Add Member Form:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub


Thank you all,

Kerry A

[ranman256]

If 'DoCmd.GoToRecord , , acNewRec' executes then yes, it will clear the form.
You'd need 1 form for viewing, then a different one for adding.

[KerryAustin]

Thats a pain in you know what! Is there a way to use an IF statement like if form is enables do not execute DoCmd.GoToRecord, else execute?

[hansendl]

I would suggest you open the AddMember form as a popup, modal form. This way, the AddMember form appears as a dialog box and doesn't impact the record you're editing. Code would look something like this (assumes your Add Member button is named "cmdAddMember" and that your Add Member form is named "frmAddStaff"). You would place this code behind the click event of the cmdAddMember button:

Private Sub cmdAddMember_Click()
    DoCmd.OpenForm "frmAddStaff", , , , acFormAdd, acDialog
    'Add code here to requery the drop down list(s), such as:
    'Me.cboStaffMembers.Requery
End Sub

[ItsMe]

As indicated in post #4 you can open forms in Add Mode by using the constant acDormAdd. Employing this in an OpenForm method would negate the need for DoCmd.GoToRecord , , acNewRec in your form's On Load Event.

[KerryAustin]

That work like a champ. Thanks for your quick fix.

[KerryAustin]

Thank you for the suggestion ItsMe. I will review up on this and make a few changes where I have the command.