Results 1 to 8 of 8
  1. #1
    knh2r is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    25

    Adding a new customer through a "List Items edit Form" popup. Then make that new customer current.

    Hey guys,

    So I have an order form that includes a customer information section. I have added the ability for the user to look up current customers by Phone #, Last Name, or Company Name using combo boxes. I have a form enabled under "list items edit form" as a data entry form to add new customers not already in the database.

    Everything seems to work great other than when I add a new customer through the pop up form, I then have to reselect the customer's phone # in order to populate the order form fields. Is there a way to make the fields filled in the pop up new customer form carry right over to the current order form where the popup occurred? Hope that makes sense.



    Also if not the other smaller issue I have is that even after "re-selecting" the customer after adding them, the last name, Phone, and Company name don't populate until I move to a new record and come back to that record. All other customer info for the newly added customer populates. I'm guessing this is because they are lookup fields and have to be required but am a bit confused as to where to do that.

    Thanks so much for the help!

  2. #2
    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,922
    Are you using code or a macro to open the pop up form? I can help if it is code but not a macro.

  3. #3
    knh2r is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    25
    Using code. Thanks!

  4. #4
    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,922
    Can you post the code you're using currently to open the pop up?

  5. #5
    knh2r is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    25
    Right now for this specific instance I'm actually using the "add item to list form" property for the phone number field. This opens the customer information form. Maybe that's the problem. Should I be using VBA instead of this property?

  6. #6
    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,922
    Hmm...have you seen this web page? http://access.mvps.org/access/lookupfields.htm

  7. #7
    knh2r is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2016
    Posts
    25
    I haven't...so what would be the proper way to give the user a way to "lookup" a customer by a couple of different criteria when entering an order?

  8. #8
    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,922
    A "lookup" on a form (a combo box) is just fine. The problem with lookup fields in a table is you never know what is really in the table field, among other issues. The not in list event is an excellent way to invoke another form to add something new. Access takes care of most of the work for you.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-10-2015, 06:33 AM
  2. Replies: 6
    Last Post: 12-11-2013, 09:27 PM
  3. Write "Edit List Items.." data back to original form.
    By ngahm in forum Database Design
    Replies: 33
    Last Post: 02-27-2012, 06:54 PM
  4. Replies: 2
    Last Post: 12-02-2010, 02:35 AM
  5. Generate a List of Items from "Many" Relationship
    By Hammer Mark in forum Reports
    Replies: 0
    Last Post: 04-20-2009, 07:30 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