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

    form with subform datasheet select criteria in main fill in sub

    I have subform as datasheet named hoursentry that is based on table name project hours and it opens in add mode, on main form there is a combox to select contractor and it puts contractor name in subform datasheet field contractor with after update event. However, I need to change the combo box because contractors could enter hours incorrectly. Hence, I want to have contractor name preselected on open so no possibility of errors.



    Attachment 15840

    Attachment 15841

    I have macro on load event to select contractor combo box.The predicament I am in is I want to limit form to specific contractor selectedfrom query and entered in contractor field in subform form. This form is basedon query for contractor and table project hours opened in add mode.
    Thanks for your assistance I do not know if pictures are viewable first time uploading screen shot

  2. #2
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    You will have to join contractor selectedfrom query to the form record source, post your queries "sql" so we can see.

  3. #3
    Jgk is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Feb 2014
    Posts
    46
    SELECT [Project Hours Query].ID, [Project Hours Query].Project, [Project Hours Query].Contractor, [Project Hours Query].DateWorked, [Project Hours Query].WorkDescription, [Project Hours Query].BillableHours, [Project Hours Query].ProjectType, [Project Hours Query].QBCode
    FROM [Project Hours Query];

    I try to filter by criteria in design view field contractor cannot get to work.
    Thanks

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

Similar Threads

  1. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  2. Replies: 3
    Last Post: 10-09-2012, 11:58 PM
  3. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  4. Replies: 1
    Last Post: 02-29-2012, 09:38 AM
  5. Replies: 3
    Last Post: 01-18-2012, 03:05 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