You must add an Unbound combobox (call it selectid) the same as the name box (but not associated with name(<-don't use reserved words as variables))
then change the record source of the mainform to
and add an after update event to the selectid as me.requery
Thank You Flash Gordon, Seems to be working for me.
I know that I have inadvertantly developed some bad habits. It is probably obvious that I had some time on my hands and bought a book, signed up for this forum and have been teaching myself as I go. I recently found the importance of naming things in a logical manner but had not thought about using the word name. probably why I had some trouble with a report printing current record and had to rename some things before it would work. Wish that I could blame some things on nutty customers but at this point I am my own crazy customer.