Results 1 to 3 of 3
  1. #1
    hellojosie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Posts
    16

    Subform, Combo Box, Data entry

    Hi there,

    I have created a booking form.

    It is a subform.

    The main form has the customer details and the subform has all the jobs for that customer.

    I have added a combo box so the user can search for a particular customers records.

    I need to add a new customer details and job details in this form also.

    Is it possible to also add a new customers details on the same form with a combo box?

    Could you please give some direction on how to do this.



    Many thanks in advance

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,697
    Yes, you can add new customer record. Not sure what you mean by 'with a combo box'?

    Review this recent thread for idea https://www.accessforums.net/forms/h...ate-19150.html
    Instead of date primary key, you would use the customer primary key.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    hellojosie is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2011
    Posts
    16
    Thanks again June7- that was most helpful!!!

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

Similar Threads

  1. Replies: 7
    Last Post: 07-15-2011, 01:58 PM
  2. Data Entry in SUBFORM
    By flsticks in forum Access
    Replies: 1
    Last Post: 04-03-2011, 08:07 AM
  3. Combo box/list for data entry.
    By geoffishere in forum Forms
    Replies: 1
    Last Post: 03-13-2010, 04:16 AM
  4. Entry into subform
    By lynchoftawa in forum Forms
    Replies: 1
    Last Post: 06-17-2009, 09:28 AM
  5. Subform Data Entry Issue
    By yuriyl in forum Forms
    Replies: 3
    Last Post: 05-14-2009, 08:49 PM

Posting Permissions

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