Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    JPP is offline Novice
    Windows 8 Access 2013
    Join Date
    Jan 2013
    Posts
    19
    Ok, here it is. Thanks again for your patience. It's been a humbling experience asking for help. I haven't been level 0 in ANYTHING regarding computers in a long time



    sample.zip

  2. #17
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You were close. In the query, you referenced the name of the label for the combo box ([order combo_Label]) not the combo box itself (they are distinct objects each with their own names). The name of the combo box is combo0. So I changed the query to the following

    SELECT Adjustments.[Order #]
    FROM Adjustments
    WHERE (((Adjustments.[Order #])=[forms]![Order combo]![Combo0]));


    The revised database is attached.

    BTW, it is best not to have spaces or special characters (#, !, (,) etc.) in your table or field names.
    Attached Files Attached Files

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. multi-step process with click of button
    By pg13Reader in forum Forms
    Replies: 4
    Last Post: 12-12-2011, 11:12 AM
  2. step and step proccess
    By toochic in forum Programming
    Replies: 5
    Last Post: 10-09-2011, 09:34 AM
  3. Search what step is the repair work in
    By blueraincoat in forum Access
    Replies: 6
    Last Post: 04-14-2011, 02:49 AM
  4. Is There a Way to Debug or Step Through VB code?
    By jeffbase34 in forum Programming
    Replies: 1
    Last Post: 05-28-2009, 08:14 PM
  5. Replies: 4
    Last Post: 04-29-2009, 04:59 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