thank a lot pr2-eugin
after i try this code. i can't see file work.xlsx.
when open other file example: nice.xlsx with double click or manually, file work.xlsx join coincided with nice.xlsx
can u explain this ??
:rolleyes:
try this code for your project
If IsNull(iOperatorsCode) Then
Me.iOperatorsName = ""
End If
Me.iOperatorsName = Me.iOperatorsCode.Column(1):cool::cool: