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)
Im 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.
You can Manual Link them
and use the ; between each feild name
hope this help
See clear as mud
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.