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

ID: Q209836

The information in this article applies to:

Microsoft Access 2000

Moderate: Requires basic macro, coding, and interoperability skills.

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

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: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

Open the sample database Northwind.mdb.

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]

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

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.

Additional query words: doubleclick update record

Keywords : kbdta McrHowto
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbhowto