Using a drop-down menu selection to also check other boxes

[ortizimo]

Is there a way to use a drop-down menu and depending on the selection use that to check additional boxes in another area of the form like the header area? Example:



From the drop-down menu select Sega and a checkbox named Cartridge is checked.

[Bulzie]

Absolutely, use the AfterUpdate event of the combobox. There are number of different ways to do the code but here is one.

If me.combobox = "Sega Then

me.Cartridge = True

Else

If me.Combobox = "Wii" Then

me.Wii = True

End If

End If

Could also use a Case Statement. Also if you want to blank out any previous checkboxes you can set them all to False to start with, then do the code above.

[June7]

Code that does not use If Then:

Me.Cartridge = Me.Combobox = "Sega"
Me.Wii = Me.Combobox = "Wii"

[ortizimo]

Absolutely, use the AfterUpdate event of the combobox. There are number of different ways to do the code but here is one.

If me.combobox = "Sega Then

me.Cartridge = True

Else

If me.Combobox = "Wii" Then

me.Wii = True

End If

End If

Could also use a Case Statement. Also if you want to blank out any previous checkboxes you can set them all to False to start with, then do the code above.

Thanks, that worked.