Results 1 to 4 of 4
  1. #1
    JLGatBrock is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    2

    How to insert a name into a table from exsisting data in form


    I have a form which I enter data specific data into it. What I want to do is to add data into a new field form existing data.

    The table shows a award of 1 or 2 up to 6 in a field called placing, this then calculates another field which gives me a figure, for instance 1 in the placing will give me 10 in the points field. These fields are set to numbers in the properties.

    What I would like to-do next is to take award placing of "1" and in a new field called "certs print" add "FIRST".

    I can't seem to get the command to work, what am I doing wrong or and what is the command.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make a table,to hold your values,AND their translation for the combo box.
    TPlacing table
    1, first
    2, second
    3....

    The combo box will have 2 columns....
    the 1 goes in the combo field,
    then use the cbo AFTERUPDATE event to fill in the Certs Print field....
    Code:
    sub cboBox_afterupdate()
    TxtCertsPrint = cboBox.column(1)      'Note,in VB columns start w zero.
    End sub

  3. #3
    JLGatBrock is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2016
    Posts
    2
    Many thanks but I can't understand where to use the code?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In form design,
    Select the combo, look at the properties,
    event tab on the properties,
    the AFTERUPDATE event,
    click the ellipsis button at the far right of the row,
    paste the code I gave above.

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

Similar Threads

  1. Replies: 1
    Last Post: 09-25-2016, 01:43 PM
  2. Replies: 3
    Last Post: 08-23-2015, 12:11 PM
  3. Replies: 1
    Last Post: 06-12-2015, 02:02 PM
  4. Updating data in exsisting drop down on form
    By sarahchadwick74 in forum Forms
    Replies: 11
    Last Post: 04-13-2015, 12:40 PM
  5. Replies: 5
    Last Post: 12-01-2014, 11:31 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