>hi,
>thank you both, it works,
>1.but
> I see all fields i have at my table i need to see only the 3 field i choise.
Add (inside the with statement, after setting the ControlSource) .ColumnCount = 3
>
>2.I need to append new record at the last field at myGRID if this field not empty.
>
Sorry, I do not understand what you want to do here
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges