Afrooman108
New member
- Local time
- Today, 08:40
- Joined
- Apr 23, 2012
- Messages
- 9
I need an if statment that will show a button if a subform number is above 500.
The button is called 'Pass'
The subform is called 'Agesubform'
The field that will be over or less than 500 is called 'Days Employed' it is on a query called 'age' and also the subform above mentioned.
I
Here is what I have so far, it doesn't work.
age.Daysemployed = ">=500" Then
Pass.Visible = True
Pass.OnClick = "Age_subform.Visible = False"
Pass.OnClick = "Pass.Visible = False"
The button is called 'Pass'
The subform is called 'Agesubform'
The field that will be over or less than 500 is called 'Days Employed' it is on a query called 'age' and also the subform above mentioned.
I
Here is what I have so far, it doesn't work.
age.Daysemployed = ">=500" Then
Pass.Visible = True
Pass.OnClick = "Age_subform.Visible = False"
Pass.OnClick = "Pass.Visible = False"