Normal Topic [Solved] data from a subform back to the main form (Read 536 times)
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
[Solved] data from a subform back to the main form
Dec 30th, 2007 at 8:45am
Print Post Print Post  
I am using FormFieldValue() to place data in subform fields from the main form. Can you please give me an example of placing data from a subform record back to the main form in Sesame 2.0

Thanks.
« Last Edit: Jan 4th, 2008 at 2:44am by Hammer »  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: data from a subform record back to the main fo
Reply #1 - Dec 30th, 2007 at 3:20pm
Print Post Print Post  
Hello BOB,

Hier is one example:

..      
If @Instr(vChoice, "Edit") > 0 and @Len(@Num(vChoice)) > 0
     {
     Label(ThisElement, vChoice)
     ForceRedraw()
     KodeBefund = @FormFieldVAlue("VariaBefund", "Kode", @Num(vChoice))
               Mikroskopie = @FormFieldVAlue("VariaBefund", "Mikroskopie", @Num(vChoice))
                        Kultur = @FormFieldVAlue("VariaBefund", "Kultur", @Num(vChoice))
                       Menge = @FormFieldVAlue("VariaBefund", "Menge", @Num(vChoice))
         Pathogen = @FormFieldVAlue("VariaBefund", "Pathogen", @Num(vChoice))
     ThrowFocus(KodeBefund)
              }
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: data from a subform record back to the main fo
Reply #2 - Dec 30th, 2007 at 5:01pm
Print Post Print Post  
Amor, Thanks for the help.


FormFieldValue was the answer. I kept trying to use it but it did not work because I was trying to return a date and did not remember that FormFieldValue always returns a string. as soon as I corrected that it worked perfectly.

Thanks again, your info was what I needed to be sure I was using the correct command.


  

Team – Together Everyone Achieves More
Back to top
 
IP Logged