Thanks Jack for the help getting my Dlookup to work. I can now get it to fill in the name field automatically when I input the ClientID from a combo table.

But .... I assumed when it entered the info it would become part of a permanent record & then I could go to a new record select a different ID an continue building records. What happens is that all the records change when I put in a new ID. That is not going to work.
Hope someone has some more tips for me.
Thanks very much

Rita

Rita -

Hmmm. I do not quite understand what is actually happening with your Database. I do not know what you mean when you say that all the records change when you put in a new ID. Is your Form bound to a Table or a Query? Just a bit more detail will help us to try and help you...

Jack