Article ID: 209836 - Last Review: June 30, 2004 - Revision: 2.0

ACC2000: How to Add New Record to a Combo Box with Double-Click

View products that this article applies to.
This article was previously published under Q209836
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Expand all | Collapse all

SUMMARY

This article describes how to set up a macro so that you can add new values to a combo box. The article uses the Orders form in the sample database Northwind.mdb as an example.

MORE INFORMATION

Follow these steps to modify the Orders form so that you can add new values to the Salesperson combo box:

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Open the sample database Northwind.mdb.
  2. Create the following new macro, and save it as Macro1:
       Macro Name   Condition                   Action
   -----------------------------------------------------
   NewRecord                                OpenForm
   OnClose      [EmployeeID] Is Not Null    RunCommand
                ...                         SelectObject
                ...                         ReQuery
                ...                         SetValue

   NewRecord Actions
   ---------------------------------------------------------
   OpenForm
      Form Name: Employees
      View: Form
      Data Mode: Add
      Window Mode: Normal

   OnClose Actions
   ----------------------------------------------
   RunCommand
      Command: SaveRecord
   SelectObject
      Object Type: Form
      Object Name: Orders
      In Database Window: No
   ReQuery
      ControlName: EmployeeId
   SetValue
      Item: [Forms]![Orders]![EmployeeID]
      Expression: [Forms]![Employees]![EmployeeID]
  3. Change the properties of the EmployeeID combo box on the Orders form as follows:
       OnDblClick: Macro1.NewRecord
   StatusBarText: Double-click to Add a New Employee
  4. Change the OnClose property of the Employees form as follows:
       On Close: Macro1.OnClose
To see how this works, open the Orders form in Form view, and then double-click the Salesperson combo box. Note that the Employees form opens. After you add a new record, close the Employees form. The new employee's name appears on the Orders form.
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbhowto KB209836
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations