Microsoft KB Archive/137739

= XL7: How to Return to Microsoft Excel After Using Access Form =

PSS ID Number: 137739

Article Last Modified on 10/23/2000

-

The information in this article applies to:


 * Microsoft Excel for Windows 95 7.0

-



This article was previously published under Q137739





SUMMARY
In Microsoft Excel, if the AccessLinks add-in is installed, you can use the Microsoft Access Form Wizard to guide you through building a data entry form for a Microsoft Excel list. Once the form is created, it may not be clear how to return to your Microsoft Excel worksheet.

The "More Information" section of this article describes how to create a sample list in Microsoft Excel, how to create a sample form in Microsoft Access, and how to return to your Microsoft Excel worksheet after you've finished working with the form.



To create a sample list
 Open a new Microsoft Excel workbook.  Create a sample list in Sheet1:

  A1: NAME     B1: CITY     C1: AMOUNT A2: Bob     B2: Dallas   C2: 10 A3: Sue     B3: Miami    C3: 9 A4: Mary    B4: Buffalo  C4: 8  Save your workbook. You must do this before you create a form.

To create a form using a Microsoft Access wizard

 * 1) Select cell A1.
 * 2) On the Data menu, click Access Form.

If the Access Form command does not appear on the Data menu, make sure the AccessLinks add-in is installed.
 * 1) In the Create Microsoft Access Form dialog box, choose New Database and then click OK.
 * 2) In the Form Wizard, double-click each of the fields listed in the Available Fields box, and then click Next.
 * 3) Choose the Columnar layout type and then click Next.
 * 4) Choose any of the Style types and then click Next.

You should now have a complete form. You can use the form to scroll all of your current records and to enter new records (new records will be automatically added to your Microsoft Excel list).

To return to Microsoft Excel

 * 1) On the File Menu, click Close. This will close your form.
 * 2) On the File Menu, click Exit.

