That works great
Thanks so much for your help
Colin
>My bad. Make it:
>
>Insert Into ('data') (AWB) Values (m.luSerial)
>
>Cetin
>
>>My Access table is called data - AWB is a numeric value as is luserial
>>
>>I get as far as this line
>>
>>Insert Into data (AWB) Values (?m.luSerial) - This line gives me a syntax error - not sure what ?m means
>>
>>Thanks
>>
>>Colin
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing