Results 1 to 7 of 7
  1. #1
    Jgk is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    46

    Want to create Form (Combobox) with subform as datasheet for entering project hours


    Attachment 15423Attachment 15424Attachment 15425


    I have attached picture shots of relationships and form I am struggling to create. This form works for contractors to enter their hours but the have to select the contractor name each time on datasheet. I want to put a cboContractorSelect unbound command in form Header and have this form shown below as datasheet and upon selecting contractor name it is entered in new record field below listed as contractor.

    Thanks for your assistance, Jay

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can set the default value of the existing control to the new one, or use this:

    http://access.mvps.org/access/forms/frm0012.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Jgk is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    46
    Thank you for your reply I tried that and no luck, My datasheet works great to open to new records only with macro enabled to open form to new and the project hours table created form from in datasheet view. However, I want to put combo box on top of datasheet and datasheet captures contractor name after update in datasheet field contractor.

    Form name : Contractor Billing Datasheet Entry
    Field Name/ControlSource: Contractor
    Form: Bound to Project Hours Table
    I have never used this forum before, so I do not know how to attach db file.

    The Contractor field in datasheet currently looks up contractor.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Looks like circular reference in relationships. http://www.codeproject.com/Articles/...atabase-Design

    Attachment Manager under the Advanced Post Editor window. Click Go Advanced below the regular post editor.
    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.

  5. #5
    Jgk is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    46
    Here is database I started and have hit a wall on. Not being used just in testing process so all changes can be made to make run. Thank you for your help. I added zip file of where i am at so far.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Did you review the article about circular relationships? Your db has two of them.

    Also, the QbCode field in Services is linked to the ID field in Projects.

    Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be TaskNum or Task_Num.
    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.

  7. #7
    Jgk is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    46
    Thank you I made those changes and read article. Database working. All numbers n calculations.

    Thx for the help in fixing database relationships

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

Similar Threads

  1. Replies: 11
    Last Post: 11-25-2013, 01:46 PM
  2. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  3. Replies: 6
    Last Post: 12-02-2010, 06:07 PM
  4. Replies: 0
    Last Post: 08-24-2010, 06:38 PM
  5. Replies: 2
    Last Post: 07-20-2010, 11:02 AM

Tags for this Thread

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