Hello,
Any help would be appreciated. I have a table and a form called "Initial Report." In the form, I enter some info on customers, which is then copied into the table automatically. This includes an autonumber. Now, I also have a form called "Sales." I want to be able to type in a number (representing the autonumber), and have other fields in the form (such as Name, DOB, etc.) be automatically filled in with the corresponding information. How can I do this? I'm very new to Access.
Thanks,
Dean
Any help would be appreciated. I have a table and a form called "Initial Report." In the form, I enter some info on customers, which is then copied into the table automatically. This includes an autonumber. Now, I also have a form called "Sales." I want to be able to type in a number (representing the autonumber), and have other fields in the form (such as Name, DOB, etc.) be automatically filled in with the corresponding information. How can I do this? I'm very new to Access.
Thanks,
Dean