Creating an Invoice with Manual Input of Order Info

Hello DarylinJ,

Please be sure to backup your database before making any changes.

You need to change the Limit to List Data Property of the Combo Box to allow edits to the field not in the list.  Open the Form in Design View and use the right mouse button to select the Combo Box you would like to edit, then select Properties at the bottom of the pop-up menu -- or select Property Sheet in the Tools Section of the Design Tab under Form Design Tools.

Under Property Sheet select the Data tab and set the Limit To List property to No.  This will allow edits to the record that are not in the list.

You need to be careful with this option however, because most Combo Boxes insert Key fields into a record which links it to a record in another table, usually with many fields.  For example, a Part No. field might link to a Parts table that has many Parts records, each with many fields, like Price, Vendor, Supplier, etc.  Allowing edits in a Combo Box to links like this will more than likely not work properly.

Another, perhaps better option, is to create a separate form to edit the list while the form is being filled out.  This option will allow the list to be updated an used by others, rather than reentered each time a new invoice is created.

Again, be sure to backup your database before making any changes.

First create a new form from the table used by the Combo Box; use text fields to edit each field in the list, or in some cases additional Combo Boxes will be used.  Then, go back to the Combo Box and open it's Property Sheet.  Select the Data tab and set the Allow Value List Edits to Yes, then add the new form to the List Items Edit Form property.  After making this change an Edit List Items button will be added to the Combo Box and a new record can be added to the list using the new form as the main form is being filled in.   This option will also work if your using a Row Source lists rather than a Control Source table and/or query.

Hope this helps.

DarylinJ