Text value available for other forms

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • doncee
    #1

    Text value available for other forms

    I thought that you could take a value created in a text box of
    one form & make it available for use by other forms in the same
    database as until you closed that database.
    If this is possible could someone post the code needed to do it.
    I believe you have to create a Public?? variable or something
    like that but am not having any luck finding documentation on
    this subject.
    Thanks for any tips on how to do this or where to look for more
    info.
    dc
    Tags: None
    • Anthony England
      #2
      Re: Text value available for other forms

      "doncee" <nodbcspam9814w anted@charter.n et> wrote in message
      news:Xns9785A2B 7380E3medbcSWBE ll@216.196.97.1 31...[color=blue]
      >I thought that you could take a value created in a text box of
      > one form & make it available for use by other forms in the same
      > database as until you closed that database.
      > If this is possible could someone post the code needed to do it.
      > I believe you have to create a Public?? variable or something
      > like that but am not having any luck finding documentation on
      > this subject.
      > Thanks for any tips on how to do this or where to look for more
      > info.
      > dc[/color]


      The form has to be open - although it can be hidden.

      strMessage=Nz(F orms!MyForm.txt MyTextbox.Value ,"")
      Msgbox strMessage


        Comment

        • doncee
          #3
          Re: Text value available for other forms

          "Anthony England" <aengland@oops. co.uk> wrote in
          news:dv4qsb$pr6 $1@nwrdmz01.dmz .ncs.ea.ibs-infra.bt.com:
          [color=blue][color=green]
          >>I thought that you could take a value created in a text box
          >>of
          >> one form & make it available for use by other forms in the
          >> same database as until you closed that database.
          >> If this is possible could someone post the code needed to
          >> do it. I believe you have to create a Public?? variable or
          >> something like that but am not having any luck finding
          >> documentation on this subject.
          >> Thanks for any tips on how to do this or where to look for
          >> more info.
          >> dc[/color]
          >
          >
          > The form has to be open - although it can be hidden.
          >
          > strMessage=Nz(F orms!MyForm.txt MyTextbox.Value ,"")
          > Msgbox strMessage
          >
          >[/color]

          Thanks for the reply. I'll give it a try.
          dc

            Comment

            Previous template Next
            Working...