Need help with next record in form

[RickK]

I have a form that I use to enter data to a table. The user enters a 10 digit number in field1 and hopefully the same number in field2. There is a field3 that compares the two other fields and if they match, then field3 shows a "match" or if they dont match it shows a "failed" result. This is done using IIf in a query. I also have the field3 formated to turn green if it equals "Match" and it turns red if it equals "failed". This all works fine.



Currently once the last field is enetred, the form will advance to a new record. And this is fine but I want it to remain on the current record if the value in field3 is "failed" . This allows the user to make the needed corrections. If it is "matched" I want it to progress to a new record.

What is the best way to do this? Should I use something like DoCmd.GoToRecord, and if so how do I account for the field3 value?

I hope this makes sense
Thanks
Rick

[pbaldy]

So the user just enters in the first 2? Set the cycle property of the form to Current Record, which will leave focus on the same record unless otherwise directed. In the after update event of the second textbox:

If Me.FirstTextbox = Me.SecondTextbox Then
  DoCmd.GoToRecord...
End If

[RickK]

So the user just enters in the first 2? Set the cycle property of the form to Current Record, which will leave focus on the same record unless otherwise directed. In the after update event of the second textbox:

If Me.FirstTextbox = Me.SecondTextbox Then
  DoCmd.GoToRecord...
End If

I was able to use this in a on exit event and it works . Now my problem is when it does go to the new record, the attention stays in the last field from the previous record. It's like it is ignoring the tab order. How can I get it to move the attention to the Field1 which is marked as tab 1?

This is what I have

If Me.Text11 = Me.Text13 Then
DoCmd.GoToRecord , , acNewRec
End If

Thanks
Rick

[pbaldy]

Try

Me.Text11.SetFocus

In the long run, you'll find naming controls with something appropriate makes it easier to maintain code.