prompt user for data entry

[Cappy]

I want to create a form in Access for the end user to enter data in a table. I know how to create the form but I want to automate it a bit by having the user prompted for information. I want them to be prompted to enter a part number and then the table will go to that part number and display all fields in the record. At this point, the user will be prompted to enter data in certain fields. Once he entered the last field, he would be prompted to enter the next part number.
Thanks for any help in this.

 

[Roger Carlson]

I would reconsider this strategy. It will work fine when the users are just
learning the system, but as they become proficient, this will be very
irritating.

A better strategy might be to lock all the controls on the form until a part
number has been entered and only then unlock all the controls. Then instead
of prompting them to enter data in to specified controls, have a prompt show
up if they DON'T enter data into specified controls. If you make these
field Required, the database will control this for you and then you can trap
the error for your custom message.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I want to create a form in Access for the end user to enter data in a

table. I know how to create the form but I want to automate it a bit by
having the user prompted for information. I want them to be prompted to
enter a part number and then the table will go to that part number and
display all fields in the record. At this point, the user will be prompted
to enter data in certain fields. Once he entered the last field, he would be
prompted to enter the next part number.