Jumat, 19 Februari 2016

[MS_AccessPros] Setting Value of Text Box


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 = ""

Is this even close to how this should be done?   Any idea what is wrong with my code?

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