Open to Blank Form

[kparadise]

Hello, I have a Form which is linked to two tables. The top section I have it liked to a Picklist table containing projects. The middle section I have the form population a 'Projects Detail' table if you will. My form contains a drop down list which has all the project titles, and once it is selected, it populates 4 fields (date, employee, LOB, Team); this is all working great. The code is: Private Sub cboACTSID_Change() Me.txtNameofProject.Value = Me.cboATCSID.Column(1) Me.txtLOB.Value = Me.cboATCSID.Column(2) Me.txtTesterAssigned.Value = Me.cboACTSID.Column(3) Me.txtFinalDate.Value = Me.cboACTSID.Column(4) End Sub Once i select from the drop down list, and the above fields populate, I can then begin to enter the remaining information. Then once I click the Save Command Button, New Record Command Button, or exit out of the form, I can see the information on the correct table (Project Details). The problem is, if I go back into the form - it will show the first record, and if the user happens to select a different project from the drop down menu, and closes the form, or clicks Save/New Record Command Button, the detail already showing will now be saved under the newly selected project number (that the user just selected). What is the best option to prevent this? Should I insert a main menu button to either EDIT or CREATE NEW record? Should I open the form to a BLANK form?

 

[kparadise]

Hello, I have a Form which is linked to two tables. The top section I have it liked to a Picklist table containing projects. The middle section I have the form population a 'Projects Detail' table if you will. My form contains a drop down list which has all the project titles, and once it is selected, it populates 4 fields (date, employee, LOB, Team); this is all working great. The code is: Private Sub cboACTSID_Change() Me.txtNameofProject.Value = Me.cboATCSID.Column(1) Me.txtLOB.Value = Me.cboATCSID.Column(2) Me.txtTesterAssigned.Value = Me.cboACTSID.Column(3) Me.txtFinalDate.Value = Me.cboACTSID.Column(4) End Sub Once i select from the drop down list, and the above fields populate, I can then begin to enter the remaining information. Then once I click the Save Command Button, New Record Command Button, or exit out of the form, I can see the information on the correct table (Project Details). The problem is, if I go back into the form - it will show the first record, and if the user happens to select a different project from the drop down menu, and closes the form, or clicks Save/New Record Command Button, the detail already showing will now be saved under the newly selected project number (that the user just selected). What is the best option to prevent this? Should I insert a main menu button to either EDIT or CREATE NEW record? Should I open the form to a BLANK form?

 

[kparadise]

I figured it out:

Form_Load()
On Error GoTo NewRecord_Err

On Error Resume Next
DoCmd.GoToRecord , "", acNewRec

NewRecord_Exit:
Exit Sub

NewRecord_Err:
Beep
MsgBox Error$
Resume NewRecord_Exit