Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: How to scroll two Combo Box at the same time? (Access)

    Hello guys this is the situation....

    I have one main form = FRMCustomers (based on Customers Table), and one Subform = SubFRMWorkorders (Bsed on a Query =Workorders and Customers)

    I’m trying to UPDATE (a Yes/No field = check or uncheck) by clicking on this Yes/No field in the subform (SubFRMWorkorders) BUT... because this subform is based in a query from 2 different tables It DIDN'T allow me To EDIT or Update the value of my Yes/No field.


    1. How can (If possible) update this Yes/No field???????
    (I want to check or uncheck).... Remember this field is in a subform based on a query from 2 different tables

    NOTE: I can't get the solution for my question number 1 (BUT IF ANY BODIE DOES PLEASE LET ME KNOW HOW TO DO IT PLEASE)

    Meanwhile.... I had an idea ===> I add a new subform SubFRMOnlyWorkOrders (Based only in the table Workorders) in the main form (based on TBLCustomer)

    It Work because both subforms bring me the workorders for the customer I request................. BUT............

    But, because those are a different SubForms , each one have their own scroll bars. And they move not at the same time.

    2. If possible to synchronize the scroll in both subform at the same time?

    NOTE: For instance if I move the scroll bar from one of the subforms, I want to scroll at the same time the other subform, in order to get and select the same record.

    Thank you…
    Helmer Horta

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 5
    Try you got the

    Link Child Fields <-> Link Master Fields Right

    That would be the first thing I would Get right

    You can Manual Link them
    and use the ; between each feild name
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

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