Hey Steve, me again. Immediately after sending my last reply I got it working. For anyone with a similar problem my solution was to first set both the LookUp Edit and Text Edit Controls Edit Value property to the same field in the DataSource, in my case to Category Code. Next set the Display Member property of the LookUp Edit to the Catgory Name so that the user sees the Category Name instead of the Category ID and set the Value Member property to Category ID. Now the create the binding so that when the LookUp Edit value is changed, in the EditValueChanged Event handler set the Text Edit control EditValue property to that of LookUp Edit edit value property.
Private Sub LookUpEdit1_EditValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LookUpEdit1.EditValueChanged
Dim lookup as LookUpEdit = sender
TextEdit1.EditValue = lookup.EditValue 'Or TextEdit1.EditValue = LookUpEdit1.EditValue
End Sub