I have a form of clients details. Each client has a Client Number. When I open the form it is designed to open blank in all fields. However if I type in an existing Client Number the rest of his details do not automatically fill the fields. I assumed they would do. Can anyone explain why? The form has subforms and they fill out correctly with the clients subform details.