Results 1 to 2 of 2
  1. #1
    Rpatrick is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2009
    Posts
    1

    Subform creating new unwanted entries

    I have a problem,



    I've been trying to reproduce the frame of Northwind Traders example database but I've hit a snag.

    On 'Orders' form, when adding a new product to the order via the subform 'Orders Subform' - my database is adding a new unwanted entry into the 'Product' table, rather then just passing the information to the 'Orders Detail' table.

    I can't figure this one out. If my working file would help, ask and I can post it.

    Thanks in advance,
    Ross

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Are you aware of the fact that Access will save the MainForm record when you move to the SubForm and then save the SubForm record when you move the focus back to the MainForm?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 06-03-2009, 10:25 PM
  2. Replies: 0
    Last Post: 04-03-2009, 01:15 PM
  3. Entries in table not showing on form!!!
    By corystemp in forum Access
    Replies: 6
    Last Post: 03-26-2009, 06:30 PM
  4. Crosstab: Grouping Monthy Entries
    By tommaccoy in forum Queries
    Replies: 0
    Last Post: 12-03-2008, 05:36 AM
  5. Make entries uneditable based on checkbox
    By acehowell in forum Programming
    Replies: 1
    Last Post: 04-19-2007, 07:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums