you read up forms first. you can't always use naked tables/queries. it is very hard to add macro code the way you want it to work. Hi can you explain more about the form?