Results 1 to 2 of 2
  1. #1
    project is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    1

    Exclamation how to store value in one text box which is related/populated by another combo box

    Hi experts,

    I have a table which has some fileds some of the fields is realy based on the selection of others
    e.g.


    Table Cat11

    Day Number
    Brand Text textbox value based on bdesc (after update of bdesc)
    Bdesc Text combobox lookup table brand
    Bage Number
    Bsex Number (1)Male (2)Female

    Lookuptable for Brand
    BRAND
    NOT STATED 000001
    A & P 000002
    A CUT ABOVE 000003


    A LA CARTE 000004
    A. RICHMAN & SONS000005
    A-LINE 000006
    A-LINEEVERDES 000007

    when a entry operator selects A & P in the desc combo the textbox automatically filled 00002
    But the DATA doesn't store in the table..............it only display on the form.

    Simply what I did to display / relationship for this two combo box
    control source of Brand =[desce]
    but this action only display whatever chose in desc that doesn't store in the table



    How to I store the brand value which is auto populated by desc.

    Any help would be appreciated.
    Last edited by project; 01-21-2010 at 01:00 PM. Reason: changes

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    What does your Table structure look like.

    Please post something so that I can see what you are doing.

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

Similar Threads

  1. Replies: 11
    Last Post: 01-06-2010, 03:27 PM
  2. Replies: 2
    Last Post: 10-09-2009, 07:34 AM
  3. Combo box to text box
    By kc21supra in forum Access
    Replies: 4
    Last Post: 08-21-2009, 01:08 PM
  4. Replies: 3
    Last Post: 03-28-2009, 06:06 PM
  5. CallTicketID populated to Order Form
    By EisBlade in forum Forms
    Replies: 0
    Last Post: 04-03-2006, 10: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