Hey All,
I have a main form and 2 subforms inside it. And I when I click a field in first subform I want the cursor to move to the second subform and set 2 field value and then leave the focus on anther field in same subform.
So far I got the part to move and set the value, but the problem is that it doesn’t move a new record and the focus doesn’t stay
Please help,
Pelerin
I have a main form and 2 subforms inside it. And I when I click a field in first subform I want the cursor to move to the second subform and set 2 field value and then leave the focus on anther field in same subform.
So far I got the part to move and set the value, but the problem is that it doesn’t move a new record and the focus doesn’t stay
Code:
[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Private Sub Text18_Click() ' this field is in the 1st subform[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Dim partN As String[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]partN = Me.Parts.Value ' this parts field is in the 1st subform[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Form_SO_ING_Serial_subform.PartNumber.Value = partN ' this parts field is in the 2ed subform[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Form_SO_ING_Serial_subform.Parts.Value = partN ' this parts field is in the 2ed subform[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]Form_SO_ING_Serial_subform.SerialNumberl.SetFocus ' this parts field is in the 2ed subform[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]End Sub[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]
Please help,
Pelerin