>What do you mean by "for the first record only"? Are you expecting it to append several records? A not eof() loop won't help...because that function won't evaluate properly for the table you are appending from (at least I don't think it will).
>
Steve:
I have two tables RefDocsAddy and RefDocsWithAddress.
RefDocsAddy has the following fields: Number, Name, Speciality, City
RefDoscWithAddress has the more fields in addtion to the fields in RefDocsAddy
What I am trying to accomplish is, if there is a matching value in the Number fields of both tables, then I want RefDocsAddy.Speciality and RefDocsAddy.City to be inserted into RefDocsWithAddress.Speciality and RefDocsWithAddress.Location. Then move to the next record and if there is a match, do the same.
Hope I am making sense. Thanks.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons