Main Form to NewForm for Input

[leean21]

hey...hope someone can help. I basically have a main input form where I am inputing some core information...then I have several command buttons of various areas I need to go (only selecting one) to complete information concerning the main input....when the new form opens, several pieces of the core information needs to carry over to the new form, but for some reason my code is not working. I used the same code from an older database where everything is working fine, so I feel like pulling my hair out...this is the code...

Private Sub Form_Current()
If NewRecordNeeded = "Yes" Then
DoCmd.GoToRecord acDataForm, "frm400Area2", acNewRec
Me![Date of Entry] = Forms![frmMainInput2]![Date of Entry]
Me![CreatedBy] = Forms![frmMainInput2]![CreatedBy]
Me![Bill] = Forms![frmMainInput2]![BillNum]
Me![BUID2] = Forms![frmMainInput2]![BUID]
Me![AreaCheck] = "400 Area"


End If
End Sub

first the new form does not open for new entry and nothing carries over
any thoughts

[GrandMasterSexay]

debug and check if the condition is satisfied. New Form will open only if the condition NewRecordNeed="Yes".

[June7]

Why is it not working - error message, wrong results, nothing? Step debug. A good tutorial for debugging is available at the below link.