ACCESS FEED: Re: [MS_AccessPros] Setting Value of Text Box

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

http://www.viescas.com/

(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

•