Need to start a new line...

[Stephanie53]

I have created a form for my Subparts..



Now here is where I am lost....

I am trying to have it after you select one of the Subparts it automatically goes to a new line to continue to select the parts needed for assembly until completed.

Here is my code now that I have...tell me what I have to do to change it...
Option Compare Database
Private Sub cboSubpartsID_Change()
Me.PrimaryID = Me.cboSubpartsID.Column(2)
Me.Discription = Me.cboSubpartsID.Column(3)
Me.Qty = Me.cboSubpartsID.Column(4)
Me.UnitCost = Me.cboSubpartsID.Column(5)
Me.NetWght = Me.cboSubpartsID.Column(7)

End Sub


Should that be AfterUpdate to start another line?

TIA for all your help and support

Stephanie

[June7]

I've never used Change event I use BeforeUpdate or AfterUpdate. Why would this start are new record? Focus will go to new record when exiting the last control of current record. In this case, use BeforeUpdate to populate the other textboxes/fields of current record.

[Stephanie53]

That worked!! Thanks!!