We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


MS Access: Forms basic data entry

James Coats
James Coats asked
Medium Priority
Last Modified: 2012-08-13
In this database attached I have a form called:


I have been able to make all the fields to do as I want except for “Tool ID” which I want to show the primary key number from table “tblToolNames”.

When I select text field to place on the form I don’t see a way in the properties dialog box to select an option to make the primary key for “tblToolNames” so that it will show in the form.

In live view all fields are “Unbound” except for “Type of Device” why I don’t know. I have also tried to enter values for “Type of Device” in the table “tblTools”.

I am trying to load in data to begin using the database and I get the following: “You cannot add or change a record because a related record is required in ‘tblInspections’. I kinda understand what is going on but I need to load up some data to start things off like the instruments names, type of device, and brand these field values will only contain a number of different values that will apply to the field below which will always be different from the fields above.

What am I doing wrong??

Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
James CoatsComputer Info. Sys. Student


Thanks, its been a while since I've worked with Access and I just got this new hot project so you will likely see a few more form questions.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.