i have a sub form that i use as a list to pick from to fill the fields in the main form. i had it working using this.......
Private Sub cardItem_GotFocus()
Me.Parent.cardID = Me.cardID
Me.Parent.cardItem = Me.cardItem
i needed to change the order of the columns in the subform datasheet view and had lots of trouble. i finely just cut the fields i wanted to move to the end of the datasheet and then just re-pasted them. that worked to get the order of columns correct but now the above code doesnt want to work anymore. i have no clue how to fix this problem.