Results 1 to 12 of 12
  1. #1
    wcook101 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    56

    Can someone figure out why i cannot create a new contact on this form set up.

    Use the customer form, navigate to a customer with contacts, then click the open contacts button. Everything works to this point. Now try to enter a new contact and check out the error message I get. It like I can only edit existing contacts, but I cant add any. If you can figure out what i need to do it would help me put a great deal. Most of what i need to do will be based on this function.
    Thanks. --Customer Tracking-davegri-v3.zipFeel free to fix it and describe what I needed to change.

  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,822
    Contact form does not know which Customer new contact should be associated with. It is irrelevant that you have opened Contact form filtered to a CustomerID. This will not automatically enter that CustomerID into foreign key field.

    Why don't you use a subform in place of listbox on main form?
    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
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Two situations arise. The attached DB handles both, using the combobox.

    Click image for larger version. 

Name:	choose.png 
Views:	14 
Size:	28.3 KB 
ID:	40643

    Click image for larger version. 

Name:	filled.png 
Views:	14 
Size:	24.0 KB 
ID:	40644

    Attachment 40645

  4. #4
    wcook101 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    56
    I did it that way originally. But I thought the finished product didnt look so good. I tried it again with a list box and it looked great. So I was hoping to male it work without going a combo box route. I might have to settle for a subform after all. Thanks

  5. #5
    wcook101 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    56
    davegri, Viola! It actually works and once I set the CusomerID visible property to No, it doesnt look so redundant. Since Im opening the customer I need already, there wouldnt be a situation where anyone should need to select a different customer anyway.
    Thanks for thinking outside the box.
    How do these things get closed as Solved? I'm quite content.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Here's how to mark it. And thank you for the thank you!

    Click image for larger version. 

Name:	solved.png 
Views:	13 
Size:	58.6 KB 
ID:	40646

  7. #7
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    I'm at work at the moment but look on my site at chart tracker elite 2020 you will see what can be done with sub form and there's a lot of people out there 100% better than me you have only been using a default design
    Mick

  8. #8
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    At home now This is some of the subforms I build but I have built programs where you wouldn't know it was a subform it's all in the formatting

    Click image for larger version. 

Name:	2019-12-31 (3) Small.png 
Views:	9 
Size:	130.8 KB 
ID:	40648
    Click image for larger version. 

Name:	2020-01-08 (2) Small.png 
Views:	10 
Size:	25.0 KB 
ID:	40649
    Click image for larger version. 

Name:	2019-12-07 Small.png 
Views:	9 
Size:	66.1 KB 
ID:	40650

  9. #9
    wcook101 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    56
    I agree. For the most part you are right, the subform is the way to go. For this particular app my contacts are only going to have 4 fields at most and I need it so i can make a quick phone call and i didnt want it cluttering up the form. Every time I tried it with a subform it looked too big and bulky. If I was going to list order history, etc.., then I would use a subform.

  10. #10
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Remember you don't have to have them in a line look at what I did on the third image here:
    https://databasedreams.createaforum....k/screenshots/

    mick

  11. #11
    wcook101 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    56
    It looks good. Im working on a different version now using the subforms instead of the list box and now that I have learned to trim it down through the properties, it doesn't look too bad. Definitely easier. I like your callback features. Thats the next thing Im going to address. Im sure I'll have some questions in the next week or so..lol

  12. #12
    Mickjav is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Location
    Margate, Kent
    Posts
    123
    Is that the primary customer I.E for large companies/Groups with muiltple address?
    I would be happy to help just let me know.

    mick

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

Similar Threads

  1. Replies: 2
    Last Post: 01-07-2020, 10:46 PM
  2. Replies: 1
    Last Post: 11-29-2017, 12:23 PM
  3. Outlook late binding to create a new contact
    By sdel_nevo in forum Programming
    Replies: 1
    Last Post: 11-09-2016, 10:15 AM
  4. Replies: 1
    Last Post: 07-04-2015, 10:43 AM
  5. Need to create a subform, can't figure out
    By mattmurdock in forum Forms
    Replies: 2
    Last Post: 06-19-2012, 08:50 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