Hmmm... My window must have been sized too small... I thought the last line was the macro substitution: &lcDo.
If your code is exactly as you've posted it, a single quote should be causing an error on this line. Offhand I don't see anything wrong with the RowSourceType assignment.
>there might be a single quote in there somewhere for like Gene's or something like that, but why would that give you an error on the line ThisForm.RowSourceType = "Rep.rep_ds"
kenweber
GCom2 Solutions
Microsoft Certified Professional