Hi i have a text box that i want to copy whatever i have in it to the next record in the same textbox and this is all determined if the checkbox next to it is checked.
I have the following code for it so far but its not working.

Private Sub txtTRKNUM_After Update()
If chkTRACKLOCK.Va lue = Checked Then
txtTRKNUM.Defau ltValue = txtTRKNUM
End If
End Sub

Is this the approach i should...

I have an access form that i created, there is a combo box on this page that is dynamic. I places a command button next to this combobox (cboPtype).
When i click this button i want to use the input box to capture the input and add it to the respective table that contains this information. this is the code i have so far, i just cant figure out how to get the captured information to go into the table i want.
The table is named PTYPE and...