Results 1 to 2 of 2
  1. #1
    rosh41 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    10

    Update form using combo box

    Hi,


    Attach is a form with a combobox listing courses created in the past. It contains the values of the TRCOST_ID field in the form.I want to update the current form's info by selecting a value in the combobox. I'm only getting it to update the TRCOST_ID field, and not all the info that's relevant to the selected course in the cbo box.
    Can anybody help me, please??Attachment 1306

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    In the After Update section of the combobox, open up the VB window and throw in a Me.Requery. That should do it for ya.

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

Similar Threads

  1. Combo box to update table in a form
    By TG_W in forum Programming
    Replies: 1
    Last Post: 05-20-2010, 01:59 PM
  2. Use combo box to update other fields
    By Shep in forum Access
    Replies: 7
    Last Post: 07-23-2009, 03:11 PM
  3. Replies: 4
    Last Post: 05-19-2009, 04:15 PM
  4. Update a combo box in real time
    By protean_being in forum Forms
    Replies: 0
    Last Post: 05-17-2008, 07:39 AM
  5. After Update for a second Combo box
    By nywi6100 in forum Forms
    Replies: 0
    Last Post: 10-23-2006, 03:07 PM

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