[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

MS Access: Forms basic data entry

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??

James Coats
James Coats
1 Solution
One thing I noticed is the form itself does not have a Record Source defined.   Granted this depends on how you have your database organized, but I'd say select the form in design view and set the Record Source (for the form) to tblToolNames.   Then Tool Id will have the ToolName_PK in the Control Source for you to select.
James CoatsAuthor Commented:
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.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now