Dim the variables

In VBA under Access (A2K) when I
Dim myStr AsString
——————-^- no space

as you did in your code listing – it throws a error. Same for your second variable