Results 1 to 4 of 4
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    combo box & field information matching.


    Another day, another question...

    I created a table from a query that lists certain types of parts (5 categories, almost 2K out of 13K parts). Then, I added a description field for those parts (i.e. diode, rectified; diode, zener, transistor, signal; etc.) to the table.

    From this table, I'm created a form that has a combo box with the description shown (see picture).
    Click image for larger version. 

Name:	Step 1.png 
Views:	12 
Size:	17.8 KB 
ID:	25640

    What I would like is for that chosen description to trigger the first of the part(s) list of that type, to appear in field text boxes on the right. Right now, that doesn't happen.

    Any suggestions??

    Thank you,

    Rebecca

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if this is a bound form to a new record table...
    when you select the combo item,
    in the afterupdate of the combo, save the record, get the record ID
    run an update query, to fill in the boxs from the table with the descriptions onto that record ID.

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    I created the form after I created the table, so I believe it is a bound form.

    The records already exist in the table. I just wanted the first one of the category to appear in the fields on the right, AFTER the category was selected from the combo box on the left.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If bound to a table, your form needs a filter that gets applied each time a combo value is selected. I think the easiest would be to create a query that returns the records that contains the description field value. On your form property sheet data tab, set this query to be the filter. Create an AfterUpdate event for the combo that simply requeries the form.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-22-2015, 03:32 AM
  2. Replies: 4
    Last Post: 11-25-2014, 11:23 AM
  3. Replies: 3
    Last Post: 03-07-2014, 10:39 AM
  4. Replies: 1
    Last Post: 10-24-2011, 08:01 AM
  5. Replies: 1
    Last Post: 08-11-2011, 11:33 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