Making fields visible without having to refresh form

[llmdb]

Hello,
I am new to Access and I can't find the answer to me question on the forum.
I am creating a database for collecting data on experts. In a form, I have two fields: one field is "number of experts" and I have two other fields: "expertise of expert 1" and "expertise of expert 2". I want the "expertise of expert 1" field to appear when the "number of experts" field is equal to 1, and both "expertise of expert 1" and "expertise of expert 2" fields to appear when the "number of experts" field is equal to 2. I want the fields to appear as soon as I enter the number of experts. I have written the following code:


If [number of experts] >= 2 Then[expertise of expert 2].Visible = TrueElse[expertise of expert 2].Visible = FalseEnd If
If [number of experts] >= 1 Then[expertise of expert 1].Visible = TrueElse[expertise of expert 1].Visible = FalseEnd If
I wrote this code in the "Current" property, and initially I had put it in the "On Click" property, but when I fill in the "number of experts" field, I have to refresh my form for the "expertise" fields to appear. I tried putting the code in the "Before Update" property, but that didn't work either...
How can I achieve this? Is there a way to program automatic refresh, for example?
Thank you for your valuable help.

[davegri]

First of all, if [number of experts] is 2,
then the test
[number of experts] >= 1 is true.

Try putting your code in the after_update event of the [number of experts] textbox.
You'll have to move out of the textbox for the after_update event to fire.

[Bob Fitz]

I understand that you are new to Access. A good database starts with good tables. Tell us more about the tables you have. Is your form and the "Controls" (you have fields in tables but you have controls on forms which may or may not be bound to the fields in the table/query that the form is bound to) bound to one of your tables.

[Welshgasman]

Please use a normal size font

[Micron]

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

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.

[llmdb]

First of all, if [number of experts] is 2,
then the test
[number of experts] >= 1 is true.

Try putting your code in the after_update event of the [number of experts] textbox.
You'll have to move out of the textbox for the after_update event to fire.

Hello everyone, thank you so much for your quick answers and great help, I had put the code in the form event and not in the textbox event, now it works! and thank you for all the other advices! Can't wait to learn more about access and sorry for the weird font. Have a good one

[davegri]

Happy to help and thanks for the star !