Results 1 to 7 of 7
  1. #1
    shellinaz is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Location
    arizona
    Posts
    4

    Main form Datasheet view subform Datasheet view

    I think this should be easy but I'm having a bit of a problem. I am creating a main form the will have a text box that I will enter data in. That information will query a table that will show up in the first subform. If one clicks any one of the records in the first form then the second form will be populated. Any help is greatly appreciated.



    shelly

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Thread title doesn't make sense. A main form in Datasheet view cannot display subform.

    Don't understand. Why would data entry in one subform create record in another subform?

    We need to know more about your data structure. If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    shellinaz is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Location
    arizona
    Posts
    4
    The main form only has a text box for entering data. Once the data is entered a I run a query that populates a subform. When you click on one of the records in the first subform it populates the second subform. I am having trouble with the parent/child relationship in the second form.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I'm not going to be able to help without examining db.
    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
    shellinaz is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Location
    arizona
    Posts
    4
    The form frmSearch is the form I am working on. I have not put the criteria in the query just yet but I will be referencing the text box Search.
    Attached Files Attached Files

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What I suggest:

    1. don't use subform for qrySearch - make this the RecordSource for main form in Single view and put the unbound search box in form Header section

    2. make the unbound search control a combobox

    3. qrySearch needs filter parameters - review http://datapigtechnologies.com/flash...tomfilter.html

    4. set Master/Child links properties - this will synchronize the related records and FK will automatically save to subform record when record initiated by input to any field

    5. define a primary key field in tblBookInfo - if you want to save the in_isbn value as FK in tblYearSales then that should be PK in tblBookInfo and the in_ID field has no purpose

    If you must use two subforms, with one linked to the other, then review http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp
    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
    shellinaz is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2012
    Location
    arizona
    Posts
    4
    The single form view won't work for this application. In time, multiple records will be available for review and I will need to see them all at the same time. I have enough information to go forward thank you.

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

Similar Threads

  1. Replies: 16
    Last Post: 09-12-2012, 08:39 AM
  2. Replies: 8
    Last Post: 08-26-2012, 11:11 PM
  3. Replies: 16
    Last Post: 01-16-2012, 09:43 AM
  4. Change row-colors i subform datasheet view
    By rolfmagne in forum Forms
    Replies: 1
    Last Post: 03-02-2011, 11:07 AM
  5. Subform, Totals, in Datasheet view
    By eww in forum Programming
    Replies: 1
    Last Post: 09-27-2010, 10:22 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