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

    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.

    Question:

    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.


    Question.
    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
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    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
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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