Re: additions-yes, data entry-yes, cannot add new record

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Thu, 3 Aug 2006 19:05:01 -0700, Floyd
<Floyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Have created a form with UserID table instead of Customer table and this
works fine. Use all 3 tables and again can't add new record. Does this help
anyone? Must be something wrong with my Customer table.

If you're trying to update three tables - you *cannot* use just a
single form based on all three tables.

Instead use a Form with Subforms.

See the Orders form in the Northwind sample database for an example -
it deals with the Orders, OrderDetails and Products tables, and it's
updateable.

John W. Vinson[MVP]
.

Relevant Pages

  • Re: Creating a New Record for Another Form
    ... the client is a combo box; ... Orders form, the new customer isn't visible; ... Is there a way to automate that "requery" and drop that new Customer right ...
    (microsoft.public.access.formscoding)
  • Re: DoCmd and ListBox events
    ... the customer is chosen, I want to set the default value for one of the fields ... in the order details subform. ... I have two buttons on the orders form for going to the next and previous ... even though the ListBox is getting updated correctly when ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form #1 that filters form #2
    ... I an not understanding what you are asking. ... customer table and the orders form comes from the orders table. ... customer form I asked it to filter by customerID in the command wizard. ...
    (microsoft.public.access.forms)
  • Re: Load data into new record using form controls (2007)?
    ... The Northwind sample database that installs with Access will give you an example to follow. ... Open the Orders form in design view, and see how the AfterUpdate event of the CustomerID combo copies the address fields as the default address for that order. ... When creating a new purchase record, I would like to use a combo box ... on that form to select the desired CUNO from the customer table. ...
    (comp.databases.ms-access)
  • Re: DoCmd and ListBox events
    ... Allen Browne - Microsoft MVP. ... the customer is chosen, I want to set the default value for one of the ... in the order details subform. ... I have two buttons on the orders form for going to the next and previous ...
    (microsoft.public.access.modulesdaovba)