Agree with davegri; with what you show, as long as the entry is greater than zero, no matter what number you enter the result will always be true for the second test. Also, don't confuse refresh with repaint, although you should not need Repaint method either. Set the visible property of the controls to No in design view. Then perhaps use
Code:
Me.[expertise of expert 1].visible = Me.[number of experts] = 1
If Me.[number of experts] > 1 Then
Me.[expertise of expert 1].visible = True
Me.[expertise of expert 2].visible = True
End If
You might want to validate entries to ensure only +ve numbers (that means no text either) can be entered.
Do yourself a favour and don't use spaces or special characters (save for perhaps underscore) in object names. Life will be easier if you simplify and shorten names as well.
Last edited by Micron; 06-02-2023 at 07:53 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.