+ Reply to Thread
Results 1 to 3 of 3

Form to display other table fields associated with combo box then store those values...

  1. #1
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Form to display other table fields associated with combo box then store those values...

    Hi,

    Attached is a working sample of my database.

    In the "Rounding Log" form I need to three associated fields to be populated when an Employee's name is selected from a Combo Box.
    The Nickname, Department and Director fields.
    Then when the record is complete those fields then be stored in the applicable fields of the "Rounding Log" Table.

    I need to be able to do this in order to generate reports from the "Rounding Log" table that are applicable to Departments and Director information.

    Hope this make sense and someone can help me.

    Thanks,
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Canada
    MS-Off Ver
    Office 2013
    Posts
    120

    Re: Form to display other table fields associated with combo box then store those values..

    You got the Nickname to work, but your combobox has a column count of 2. You need to increase this to the number of columns it needs to hold. For example you try to reference column 4 in department (=[Combo29].[column](4)), but if combo29 has only 2 columns, nothing will be put in department. The director field could then be defined as =[Combo29].[column](3). I believe this is what you are asking for...

    If you do not want the combo box to show all this data, just the name, change the column widths field to 0";1";0";0" (0" for the first field, 1" for the second, 0" for the third, etc.)

    Hope this is what you are looking for. Lastly, you can set a requery for combo29 on the record change (not sure again which event, but this is bonus) which should fix the other fields once you go through the records.

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2015
    Location
    Uvalde, TX
    MS-Off Ver
    2010
    Posts
    720

    Re: Form to display other table fields associated with combo box then store those values..

    Hi,

    Thank you for the reply. That did the job. It was driving me crazy. I was so focused on one area that I missed the simple details of the other.

    Thank you very much.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-29-2014, 01:49 PM
  2. VBA User Form Check all Fields Filled Combo box
    By JSmith1504 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2014, 10:55 AM
  3. How a combo box(form control) to display its list index value in Greek
    By Sotiris Kordas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 05:37 AM
  4. How to make a form to accept different values and store them in a excel sheet.
    By xmaverickx1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2013, 12:54 PM
  5. How to Display All the fields into User Form When selecting any row
    By angeld27 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-22-2011, 04:37 AM
  6. combo box to display multiple records in a form
    By stats09 in forum Access Tables & Databases
    Replies: 12
    Last Post: 12-15-2010, 12:41 PM
  7. use combo box to select pivot table page fields
    By penfold in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2008, 09:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1