I am attempting to set the value of a Text box on a report based on the value of an Options Box.
Below is my attempt that is not working.
the options box has two valued 1=Champions, 2 = Huskies
Private Sub Report_Load()
If Forms!f_TeamTournamentSetup!OptBoxTournamentName = 1 Then Me.txtChampions = "Champions"
ElseIf Forms!f_TeamTournamentSetup!OptBoxTournamentName = 2 Then Me.txtChampions = "Huskies"
Else: Me.txtChampions = ""
EndSub
If Forms!f_TeamTournamentSetup!OptBoxTournamentName = 1 Then Me.txtChampions = "Champions"
ElseIf Forms!f_TeamTournamentSetup!OptBoxTournamentName = 2 Then Me.txtChampions = "Huskies"
Else: Me.txtChampions = ""
EndSub
Is this even close to how this should be done? Any idea what is wrong with my code?
thanks,
Bill
Minnesota, at Mall of America
__._,_.___
Posted by: Bill Singer <bill.singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1128) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar