MS Access: Forms basic data entry

Posted on 2011-04-22
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??

Question by:James Coats
    LVL 5

    Accepted 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.

    Author Closing Comment

    by:James Coats
    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now