Cheers Mike
Was unsure at first but worked a treat...
catergorycode, is bound to the destination column in the table the rest of the code went as follows...
Private Sub SubCat1_AfterUpdate()
Me.categorycode.Value = [MainCat1] & [SubCat1]
End Sub
Private Sub SubCat2_AfterUpdate()...
How can i insert the output into a field, which was generated by the following expression...
=[MainCat1] & [SubCat1] & "," & [MainCat2]+[SubCat2] & "," & [MainCat3]+[SubCat3] & "," & [MainCat4]+[SubCat4] & "," & [MainCat5]+[SubCat5] & "," &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.