12-14-04, 12:05 #1Registered User
- 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)
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.
12-14-04, 14:26 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
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 namehope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON