How do I update on changing records?

[retro]

I have a form (Games) based on a table of the same name. There are two combo boxes in the table (both lookup from other tables). These are called GameFormat and GameMediaType.

I only want GameMediaType to be visible when one value is chosen in GameFormat. I used the following as an AfterUpdate event for GameFormat:

Private Sub GameFormat_AfterUpdate()
If GameFormat.Value = 1 Then
GameMediaType.Visible = True
Else: GameMediaType.Visible = False
End If
End Sub

This works great on the current record. It will hide and show the combo box as required. However, when I load the form, or change record, it ignores this code. I can see that this is, of course, because the combo box has not been updated, but how do I get it to hide or show when I load a new record?

Thanks in advance for any assistance!

 

[RuralGuy]

You need similar code in the current event of the form.

 

[retro]

That worked great, thanks!

 

[RuralGuy]

Glad I could help.