Results 1 to 5 of 5
  1. #1
    TenOc is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    94

    How to add record with button on main form but data is on subform

    I am a newbie. Win 7 Access 2016



    I can't get my mind around a possible solution on how to start to solve a problem I have. I need help on how to start.

    I have a database where in table "tabBeneficiaries" that contains all the personal information (nam, DOB, Address etc.) about beneficiaries. Another table "tabChilden" contains informaion on the children linked to the parent on tabBeneficiaries. A third table "tabDistributions" has information on distributions.

    I have created a form "frmAllBeneficiaries" with 4 tab subforms. See attached screenshotClick image for larger version. 

Name:	Main 2019-03-15_12h50_30.jpg 
Views:	18 
Size:	103.3 KB 
ID:	37854.

    When one selects a name in the "Find Beneficiary" field in the Header all works well. The correct information is displayed.

    However, I do not know how to start to get the top three buttons to work. For example to add a new record I want to be able to start typing in the "Common Name" field, but since this is the same name as appears when one finds a beneficiary I get a error.

    Any suggestion on how to start is welcome. Remember I am a newbie!!!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What error?

    Find Beneficiary combobox is UNBOUND?

    If you are on a new record row, there should not be any name showing in "Common Name" box.
    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
    TenOc is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    94
    Quote Originally Posted by June7 View Post
    What error?

    Find Beneficiary combobox is UNBOUND?

    If you are on a new record row, there should not be any name showing in "Common Name" box.
    You are correct. When I type in the subform Main first field that is "Common Name" I get an error saying I must type in the field that is the lookup up field in the combobox. Click image for larger version. 

Name:	Main 2019-03-15_15h28_17.jpg 
Views:	18 
Size:	158.2 KB 
ID:	37859

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I don't know your data structure and relationships nor property settings of form so really hard to advise why this happens. If you want to provide sanitized version of 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.

  5. #5
    TenOc is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Feb 2015
    Posts
    94
    I think I have solved the problem. If I place the three buttons INSIDE the subform it works.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-08-2017, 07:18 PM
  2. Replies: 10
    Last Post: 07-05-2017, 11:31 AM
  3. Replies: 11
    Last Post: 02-22-2015, 01:25 PM
  4. Replies: 6
    Last Post: 05-18-2013, 12:48 AM
  5. Replies: 1
    Last Post: 10-13-2010, 12:40 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
  •  
Other Forums: Microsoft Office Forums