Others

How to Create an Access Book and Author Form with a ComboBox

Muhammad Talha Oct 10, 2026 868 views

Question details

The user needs to configure a Microsoft Access form that allows selecting an author by their name from a dropdown, while storing the corresponding AuthorID as a foreign key in the Book table.

How to Create a Book and Author Form Using a ComboBox in MS Access

Product: Microsoft Access
Device & OS: not provided
Scenario: Designing a user-friendly database data entry form where relational foreign keys are managed smoothly.
Observed behavior: The goal is to bind a form control to the AuthorID field but visually display the associated author's name to make data entry intuitive.

Before you start

Ensure you have already created an 'Author' table with an AutoNumber primary key (AuthorID) and a 'Book' table containing a corresponding Number field (AuthorID) to act as the foreign key.

Solution 1Recommended

Configure the ComboBox on the Book Form

Use the Property Sheet to bind the combo box to the AuthorID field while hiding the ID column so only the author's name is visible.

This is the standard approach for handling a one-to-many relationship in Access forms. By adjusting column widths, you can seamlessly store the underlying numerical ID while presenting a readable text string to the user.

Open Form in Design View

Right-click your Book form in the navigation pane and select 'Design View'.

Add a Combo Box

From the Form Design toolbar, click the 'Combo Box' icon and click on your form to place it. Cancel the wizard if it pops up.

Set the Row Source

Open the Property Sheet (F4), go to the 'Data' tab, and set the 'Row Source' to a query or directly to your Author table, ensuring it selects AuthorID first, then the Author Name.

Bind the Control

Still in the 'Data' tab, set the 'Control Source' to the AuthorID field of your Book table. Set the 'Bound Column' to 1.

Hide the ID Column

Switch to the 'Format' tab in the Property Sheet. Set 'Column Count' to 2, and set 'Column Widths' to '0cm;3cm' (or '0";1.5"'). This hides the numerical ID and displays the name.

ComboBox Configuration: Your form will now correctly store the numeric ID behind the scenes while displaying the user-friendly author name in the interface.

Solution 2

Add New Authors using the 'Not In List' Event

Allow users to add an author who isn't currently in the database directly from the combo box.

Solution 3

Manage Multiple Authors Using a Junction Table

If books in your database can have multiple authors, a single foreign key is insufficient. You must use a many-to-many design.

Free Microsoft Office alternative

Streamline Your Office Work with WPS Office

While Microsoft Access manages complex databases, keeping up with everyday productivity tasks requires an efficient office suite. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for all your word processing, spreadsheet, and presentation needs.

1. Download the Installer: Visit the official WPS Office website and download the free installation package.
2. Install the Suite: Run the installer file and follow the straightforward on-screen instructions.
3. Start Creating: Open WPS Writer, Spreadsheet, or Presentation to immediately start working with your existing Microsoft Office files.

Free and lightweight Office suite with a built-in PDF toolkitFully compatible with Microsoft Office formats (DOCX, XLSX, PPTX)Familiar user interface for seamless migration without a learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my combo box display the AuthorID number instead of the Author's name?

This happens when the column displaying the ID is not properly hidden. To fix this, select the combo box, open the Property Sheet, go to the 'Format' tab, set the 'Column Count' to 2, and set the 'Column Widths' property to 0cm;3cm (or 0";1.5"). The zero width hides the first column (the ID).

How do I prevent users from typing in author names that don't exist in the database?

You can enforce data integrity by selecting the combo box in Design View, navigating to the 'Data' tab in the Property Sheet, and setting the 'Limit to List' property to 'Yes'. This restricts input to only the authors currently in your Author table.

Can I have multiple authors for a single book using this combo box method?

Storing a single AuthorID in the Book table restricts you to a one-to-many relationship (one author per book). To handle multiple authors, you need a many-to-many design involving a junction table (e.g., BookAuthors). You would then place your combo box inside a continuous subform rather than directly on the main book form.

Office Quick Solutions