Results 1 to 2 of 2
  1. #1
    Kevo is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Location
    Kodiak, Alaska
    Posts
    86

    Open form to specific record based on combobox

    OK, here is what I want to do....have a combobox that only displays records on a table where field = 0..... got that.....now I want to be able to click on record in combobox and have it open up the form to that specific record.....




    So far I have combobox with...
    SELECT tblLoad.LoadID, tblLoad.LoadDate, tblLoad.AutoclaveID, tblLoad.LoadNumber, tblLoad.[Cycle Complete] FROM tblLoad WHERE (((tblLoad.[Cycle Complete])=0));

    Bound Column is 1

    This works to limit records shown in combbox....yea!
    Now I can't figure out how to open form to that particular record.....have tried several things in afterupdate of combobox....but no luck

    Any help would be appreciated.

    Kevin

  2. #2
    Kevo is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2011
    Location
    Kodiak, Alaska
    Posts
    86
    Nevermind.....solved my own issue! Thanks!

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

Similar Threads

  1. Replies: 4
    Last Post: 04-20-2013, 10:12 AM
  2. Open form on specific record
    By iky123 in forum Forms
    Replies: 1
    Last Post: 04-11-2012, 09:56 AM
  3. open form based on combobox
    By bigmac in forum Forms
    Replies: 3
    Last Post: 04-09-2012, 11:25 AM
  4. Open form to specific record
    By Two Gun in forum Forms
    Replies: 7
    Last Post: 11-09-2011, 10:00 AM
  5. Replies: 2
    Last Post: 08-11-2011, 10:02 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