hi,
ok,
still waite the answer.
>>
>>1.please kindly respond with constuctive answers.
>
>I did! Both my answers, 1 and 2 were constructive. My third comment, besides scolding you, still held a constructive comment, as you've picked out in your point 2. below!
>
>>don't you think that we have other work to do?
>
>Don't YOU think WE've got other work to do - besides working out every small error message you encounter.
>
>>
>>2.the 2 tables have the same data type? i'm sure
>
>>
>>3..error message at this line under
>>
>>for lcField==LookUp(Evaluate("Bill." + lcField), lcField, Evaluate("Bill." + lcField))
>
>Thank you. How are we to know otherwise.
>
>PS your English seems to be improving.