Results 1 to 5 of 5
  1. #1
    BarneyH4 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2013
    Location
    Ohio
    Posts
    5

    Auto fill "cust no." field when "cust name" field has been focused

    CUSTOMER NAME TABLE:



    CUST NAME CUST NO
    ZOLOTY ELECTRIC 205506
    ZOLOTY ELECTRIC 108345
    ZOLOTY ELECTRIC 58979

    When the user types the Name… ZOL.. then have “ZOLOTY ELECTRIC” will finish filling in the field, while at the same time “CUST NO” field has all three (3) numbers appear, waiting for the user to make a selection.
    I have the CUST NAME set to a Lookup Table, (35,000) records. This part is working OK.

    What I NEED is the part where the CUST NO somehow connects to the CUST NAME field and then List the different CUST NO's so that the user can SELECT the appropriate CUST NO for this record.
    Thanks for any direction you can help me with.
    Barney Henley

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Have you considered a combobox with your Lookup Table as its RowSource ?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    IF you're using a combo box, the query behind it would have CUST NAME;CUST#. The user picks a name, but the combo VALUE = CUST#.

    If you're using companies, a company combo to 1st pick the company, then the 2nd combo will fill with ONLY those employees.
    I myself use list boxes to see all the contents.
    Is this what you mean or am I way off base?

    Click image for larger version. 

Name:	pick3-alt.png 
Views:	10 
Size:	14.8 KB 
ID:	16694

  4. #4
    BarneyH4 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2013
    Location
    Ohio
    Posts
    5
    I will give it a try. Thanks

  5. #5
    BarneyH4 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2013
    Location
    Ohio
    Posts
    5
    On the form the 1st field is [CUST NAME]. This fills in automatically and is OK.
    The 2nd field is [CUST NO] Once the 1st field is selected the 2nd field looks for all CUST NO's that are associated with that [CUST NAME].
    Zoloty Company many have 3 different CUST NO's.
    I need the user to then have the opportunity to select 1 of the 3 CUST NO's.
    I have a table that contains all of the CUST NAMES and their associated CUST NO's. 30,000 records. The same company may have 50 records, however, the CUST NO's are Unique.
    The user needs to select the CUST NO that applies to a Specific Incident that belongs to a location.
    Each CUST NO identifies a different State, Such as Ohio, WV or NY.
    Thanks for you willingness to help me, it is much appreciated.
    Its said that successful people are guided by two qualities, Conviction and Ignorance. Now you know where I excel.

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

Similar Threads

  1. Replies: 3
    Last Post: 04-22-2013, 06:08 AM
  2. Replies: 1
    Last Post: 02-17-2013, 04:46 PM
  3. Replies: 5
    Last Post: 02-05-2013, 10:57 PM
  4. Replies: 2
    Last Post: 09-29-2012, 11:22 PM
  5. Replies: 16
    Last Post: 07-22-2011, 09:23 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