LjushaMisha
Registered User.
- Local time
- Today, 17:48
- Joined
- Mar 10, 2017
- Messages
- 55
Hello to All.
I've made ACCESS CONTINUOUS form like the one in attachment (which is actually Excel shape)
Main wish is to have VALUES in controls Range_m;Area_m2; Volume_m3; and their VISIBILITY depending on Measure unit value ("m", "m2", "m3")
On AfterUpdate event of MeasureUnit I've made some code about problem
If Me.MeasureUnit = "m" then
Me.Area_m2.visible = False
Me.Area_m2.Value = 0
Me.Volume_m3.visible = False
Me.Volume_m3.Value= 0
Me.Range_m.visible = True
Me.Range_m.Value = 2 * x + 2 * y
...
...
...
End if
BUT, BUT, BUT:banghead::banghead::banghead:ecord settings by code change also apperance of controls in previous record.
Any HELP, Please.
I've made ACCESS CONTINUOUS form like the one in attachment (which is actually Excel shape)
Main wish is to have VALUES in controls Range_m;Area_m2; Volume_m3; and their VISIBILITY depending on Measure unit value ("m", "m2", "m3")
On AfterUpdate event of MeasureUnit I've made some code about problem
If Me.MeasureUnit = "m" then
Me.Area_m2.visible = False
Me.Area_m2.Value = 0
Me.Volume_m3.visible = False
Me.Volume_m3.Value= 0
Me.Range_m.visible = True
Me.Range_m.Value = 2 * x + 2 * y
...
...
...
End if
BUT, BUT, BUT:banghead::banghead::banghead:ecord settings by code change also apperance of controls in previous record.
Any HELP, Please.