I have form with a subform set to continuous mode. I have a second form that is a search form that the user uses to search and the searched number is stored in txtSearchNum. This number is used to populate a row in the database. The code below works as long as the new record does not have the focus. If the focus is in the new record the program stops at the line RunCommand acCmdRecordsGoToNew. Is there a way to check to see if the focus is in the new record so I can prevent this line from executing?
If Not IsNull(Me.txtSearchNum) Then
Me!Child808!cmbJob = Me.txtSearchNum