<div>
Use the Form_Current event and call the AfterUpdate event of the combo box, something like:<br><pre><code class="code-1 nolinks" id="code-20-43303801-1"><span>Private Sub Form_Current()</span>
<span></span>
<span></span>
<span>&nbsp; &nbsp; Call cbo_TypeRapport_AfterUpdate</span>
<span></span>
<span></span>
<span>End Sub</span>
</code></pre>
</div>


<div>
ThX Dale, I will try this tomorrow.
</div>


<div>
@Dale: That does not do the trick. Even the first record, when opening the form, does not react on the code in typereport_afterupdate().<br>The afterupdate event is executed, I have placed a msgbox in the afterupdate() but, the form does not change when the combobox has the value "Bijlage". I also tried {Refresh} &nbsp;and {Repaint} in the afterupdate event, but nothing changes on the form. It really only change when I use the combobox.<br>Do you have some other suggestions?
</div>


<div>
No, it is one form with a combobox en some conditional objects. The button en de field fullpathname needs to show conditional on the value of the combobox.<br>But in the planning is also a subform which is conditional on the combobox value.
</div>


<div>
Guessing...<br>have you manipulated Dale's code accordingly ?<br><pre><code class="code-1 nolinks" id="code-20-43305144-1"><span>Private Sub Form_Current()</span>
<span>&nbsp; &nbsp;If Me.TypeReport.Value = "Bijlage" Then </span>
<span>&nbsp; &nbsp; &nbsp;Call cbo_TypeRapport_AfterUpdate</span>
<span>End If</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
Hi John, I didn't but now I did. It makes no difference. It was to be expected because the after_update trigger is fired through the Form_Current (I have checked that using a msgbox) but the code in the after_update does not change the form. I have also tried any variation as, repaint, refresh, requery, but nothing...
</div>


<div>
Lets take it from the start<br>At first any chance you can share a stripped down copy to see what is going on.<br>As soon you change the record on a form the Current event should fire so maybe we are missing something
</div>


<div>
From the start is fine by me. As I replied, the Current event is fired and therefore also the after_update. I had placed a msgbox in the afterupdate to check. I will make a stripped down copy of the problem. How do I upload it to you?
</div>


<div>
I am attaching a very very simple demo app to check<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1564089/Visibility.accdb" rel="ugc">Visibility.accdb</a>
</div>


Visibility.accdb

<div>
<a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1564095/Database1.accdb" rel="ugc">Database1.accdb</a><br>Hi John, I have a stripped version of the problem uploaded. Record 8 holds the value "Bijlage". if you skip through the records, you will see that the form does change when entering the 8th record.
</div>


Database1.accdb

<div>
The problem is that your combo carries extra spaces..<br>I will upload fixed version...as soon my VM allows me....
</div>


<div>
Here you go (needs some refactoring) ..:)<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1564101/Database1-fixed.accdb" rel="ugc">Database1 fixed.accdb</a>
</div>


Database1-fixed.accdb

<div>
Hi John, indeed now the form changes when I loop through the records from 1 to 8. But...when I do a previous record (from 8 to 7) the controls are still showing though there is not the value "Bijlage" anymore in the combobox.<br>What do you mean with..."there are extra spaces in the combobox"?
</div>


CroetOne

<div>
@John: I see what you mean. Indeed the operation goes smoothly now. Thanks for the assist.<br><br>
</div>


<div>
<div class="content wysiwyg-content fr-view">
In MS ACCESS I have a form with a combo box. Depending on the value that is chosen by the user, the form shows an other control (field). Moving between the records, the form does not shows the control that belongs to the chosen value in the combo box. The only way the control is showing, is on the "on click" event of the combo box.<br>I have tried several alternatives approaches, using a next-record-button and force the form to repaint. I have &nbsp;tried the current form event with this code (works on the click event of the combo box):<br><pre><code class="code-10 nolinks" id="code-10-29218506-1"><span>If Me.TypeReport.Value = "Bijlage" Then</span>
<span>&nbsp; &nbsp; Me.knpBrowseBijlage.Visible = True</span>
<span>&nbsp; &nbsp; Me.FullPathName.Visible = True</span>
<span>Else</span>
<span>&nbsp; &nbsp; If Me.knpBrowseBijlage.Visible = True Then</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; Me.FullPathName.Value = ""</span>
<span>&nbsp; &nbsp; End If</span>
<span>&nbsp; &nbsp; Me.knpBrowseBijlage.Visible = False</span>
<span>&nbsp; &nbsp; Me.FullPathName.Visible = False</span>
<span>End If</span>
<span></span>
</code></pre>Although the event occurs (I placed a msgbox in the code) the form does not shows "Me.knpBrowseBijlage" nor "Me.FullPathName".<br><br>Using the combo box:<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1563875/AccessForm.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w26/1563875/AccessForm.PNG" class="fr-fic fr-dib"></a>When entering the record using the next of previous record button:<br><a href="https://filedb.experts-exchange.com/incoming/2021/06_w26/1563876/AccessForm2.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/06_w26/1563876/AccessForm2.PNG" class="fr-fic fr-dib"></a>Using the next or previous record button the form should give me also the two other controls when the combo box contains "Bijlage".<br>I'm not new to Access but this seems to me as a beginners problem....
</div>
</div>


AccessForm.PNG

AccessForm2.PNG


In MS ACCESS I have a form with a combo box. Depending on the value that is chosen by the user, the form shows an other control (field). Moving between the records, the form does not shows the control that belongs to the chosen value in the combo box. The only way the control is showing, is on the "on click" event of the combo box.
I have tried several alternatives approaches, using a next-record-button and force the form to repaint. I have  tried the current form event with this code (works on the click event of the combo box):
If Me.TypeReport.Value = "Bijlage" Then
    Me.knpBrowseBijlage.Visible = True
    Me.FullPathName.Visible = True
Else
    If Me.knpBrowseBijlage.Visible = True Then
        Me.FullPathName.Value = ""
    End If
    Me.knpBrowseBijlage.Visible = False
    Me.FullPathName.Visible = False
End If
Although the event occurs (I placed a msgbox in the code) the form does not shows "Me.knpBrowseBijlage" nor "Me.FullPathName".
Using the combo box:
When entering the record using the next of previous record button:
Using the next or previous record button the form should give me also the two other controls when the combo box contains "Bijlage".
I'm not new to Access but this seems to me as a beginners problem....

How to show a control based upon the value of a field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.