Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
  1. #31
    balderman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    55
    Here are some screenshots and I hope they help you and better show what I am trying to do.



    Click image for larger version. 

Name:	1.jpg 
Views:	10 
Size:	135.7 KB 
ID:	31755Click image for larger version. 

Name:	2.jpg 
Views:	10 
Size:	96.9 KB 
ID:	31756
    Click image for larger version. 

Name:	3.jpg 
Views:	10 
Size:	74.7 KB 
ID:	31757Click image for larger version. 

Name:	4.jpg 
Views:	10 
Size:	53.4 KB 
ID:	31758
    Click image for larger version. 

Name:	5.jpg 
Views:	10 
Size:	51.0 KB 
ID:	31759

  2. #32
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,917
    If it is not a security violation for you, it would be very helpful if you could zip up your db and attach it to a post. Do a Compact and repair first. You should remove any sensitive data as needed.

  3. #33
    balderman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    55
    I made some changes. Instead of having the button to open the form, I just created it as a another subform on a tab control. But my problem of not being able to add a new record is still happening.

    I have previously had problems with attaching the database to a post so I uploaded it to dropbox.

    https://www.dropbox.com/s/6yunrjz1j3...abase.zip?dl=0

    Thank You!

  4. #34
    balderman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    55
    I have fixed the problem! Thank you!

  5. #35
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Your form "frmMaintContInfo" record source should only have the table "tblMaintContract" in it (NOT tblCustomers). Add the FK field for Customers and set the sub form control "Link Master"/"Link Child" fields.


    IMO, You really ought to fix the field names in the tables. See the field names in Post#29...


    Edit... seems you solved the problem as I was posting.


    Good luck with your project.............

  6. #36
    balderman is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Nov 2017
    Posts
    55
    What is the problem with my field names?

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 01-08-2015, 02:08 PM
  2. CDate and CStr issue with "Invalid Use of Null" Issue
    By excellenthelp in forum Queries
    Replies: 3
    Last Post: 07-25-2014, 01:34 PM
  3. Replies: 22
    Last Post: 05-21-2013, 07:54 PM
  4. problems please help
    By stryder09 in forum Access
    Replies: 1
    Last Post: 02-15-2011, 02:24 PM
  5. Replies: 1
    Last Post: 03-31-2010, 11:57 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