subform automatically moving to next record

B

Brandie

Ok....I have no clue what is happening. I have a form with a subform on it.
I have "BAA_RFP_RFI_Number" on both. On the subform's BAA_RFP_RFI_Number
control I have an event procedure:
Private Sub BAA_RFP_RFI_Number_Change()
Form_frmStanEvalQry.BAA_RFP_RFI_Number.Value =
Form_frmInfoEval.BAA_RFP_RFI_Number.Value
End Sub
(frmStanEvalQry is the main form and frmInfoEval is the subform)

It works fine but the instant that I enter the number into the subform it
automatically moves to the next record. The main form stays the way it
should with the BAA/RFP/RFI Number that I entered. But the subform should
remain on the record I entered so that I can enter information into 3 other
fields. What is going on? Please help!
 
O

Ofer

I would check two things
1. The TAB order, check if the TAb order number of the field you update if
its the biggest one.
2. Check if there is any code on the after event of the field you update,
that might tell it to move to the next record.
 
Top