Problem with new record on form

[Noreene Patrick]

I have a form that is tied to a table called Log Pending. On my form is Log in, Log out, and Picker ID.

I have a button that is called new record so they will not have to use record selector (I will remove these when the form works correctly)..but each time I try to add a new record, the form jumps back to the first record. What is wrong with this form?

I'm sure it is something simple.

Thanks, Noreene

One more thing, when I go to new record, I have a combo box that I select the pickerid from and when I select a new pickerid, that is when it goes back to the first record and changes that pickerid.

 

[dcx693]

Please post the code you are using in the new record button.

 

[Noreene Patrick]

I used the wizard to write the code:

Private Sub cmdnewrecord_Click()
On Error GoTo Err_cmdnewrecord_Click

DoCmd.GoToRecord , , acNewRec
Exit_cmdnewrecord_Click:
Exit Sub

Err_cmdnewrecord_Click:
MsgBox Err.Description
Resume Exit_cmdnewrecord_Click

End Sub

Thanks, NOreene

 

[ghudson]

Sounds like your form is requerying when the combo box is selected.

 

[Noreene Patrick]

I went back and looked at the combo box and I see that I chose the last option, "find a value on my form based on value I select in combo box"

I changed it to another option and it seems to be working correctly now.

Thanks for steering me in the right direction.

Noreene

 

[Noreene Patrick]

Thanks Pat,

It works great

Noreene