There are two forms: FormA and FormB, both are open. FormA has a controller named "controlerA" and formB has "ControlerB". Is it possible that controlerB in formB gets the value in ControlerA each time ControlerA updates or changes?
Thank you
There are two forms: FormA and FormB, both are open. FormA has a controller named "controlerA" and formB has "ControlerB". Is it possible that controlerB in formB gets the value in ControlerA each time ControlerA updates or changes?
Thank you
I'm sure it's possible, but more details or sample data/code/graphics would help readers understand your situation/opportunity.
What tables/queries underlay your forms?
Why are you duplicating data? How are these records related? As Orange said, certainly possible but more information is needed. Code in ControlerA AfterUpdate event would likely be needed.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
does the afterupdate of ControlerA in formA puts data in FormB?
I have simplified the DB here and attached it.
FormA relies on a query showing Jack's payment if working is No. when Working is checked to Yes, ControlerA, which is yellow here, shows the sum. FormB is not relying on a table or query, but i need the controlerB to show the number in ControlerA. please lets put aside what is the logic behind this, and see how these two are doable:
1- ControlerA should show the Sum instantly after the "working"checkbox is checked to yes.
2- Any change in controlerA shows up in ControlerB on formB rightaway.
please ignore file ariansman2 and review ariansman3. i could not delet ariansman2.
thank you
Impossible to put aside logic. Logic is what programming is based on. However, ignoring your reasons for this arrangement, consider:
The Sum calc will not adjust until record or the data edit is committed to table. Record entry/edit is committed when: 1) close table/query/form; or 2) move to another record; or 3) run code to save.
There is no ControlerA. Both textboxes are named ControlerB.
Then options:
1. expression in FormB textbox: =[Forms]![FormA]![ControlerB] then open FormB or if already open have to Refresh the form (button on ribbon or code)
2. code behind FormA sets value of FormB textbox - the real trick is figuring out what event to use, perhaps AfterUpdate of form
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.