Sabtu, 20 Februari 2016

Re: [MS_AccessPros] Setting Value of Text Box

 

Bill-


I assume the form is open while the report runs.  If so, then you can set the Control Source of the text box to:

=Choose([Forms]![f_TeamTournamentSetup]![OptBoxTournamentName], "Champions", "Huskies")

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Feb 20, 2016, at 6:47 AM, Bill Singer Bill.Singer@at-group.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


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



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: John Viescas <johnv@msn.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1129)

.

__,_._,___

Tidak ada komentar:

Posting Komentar