Reference Control in Other Form

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Reference Control in Other Form

Author

Message

hfshultz

Posts: 17

Posted: 07/28/2004, 7:09 AM

OK, this sounds like a stupid problem and I hope what I'm doing wrong is obvious so here goes:

I have a page with three forms on it, one called "Tickets" , "TicketHistoryView", and "TicketHistoryAdd". I cannot for the life of me get an email even that fires AfterInsert on the TicketHistoryAdd form to read a value from the Tickets form. I'm trying to call the field using the variable Tickets.ClientID.value and I'm not receiving anything back so it's coming up blank. Here's my code:

  If TicketHistoryAdd.VisibleClient.value = 1 then  
        With CreateObject("CDONTS.NewMail")  
        .From = CCDLookUp("Email", "Clients", "ClientID="&Session("UserID"), DBhddb)  
        .To = CCDLookUp("Email", "Clients", "ClientID="&Tickets.ClientID.value, DBhddb)  
        .Subject = "InQueue Message for Ticket #"&Tickets.TicketNumber.value  
        .Body = "Message from "&Session("UserLogin")&":<BR><BR>"&TicketHistoryAdd.Comment.value  
        .BodyFormat = 0  
        .MailFormat = 0  
        .Send  
		End With  
  End if

I think I'm probably just doing something wrong. If I have to, I'm going to have to put hidden textboxes in the TicketHistoryAdd form and have them pull the values I need but I'd rather not do that and have the extra overhead if possible.

Thanks,
Frank

hfshultz

Posts: 17

Posted: 07/29/2004, 8:55 AM

OK, I really have been beating my head against the wall with this one. Is it not possible to call a field from another form? I've even tried moving the SendEmail event to the BeforeInsert event without any luck. It just won't pull the value from the other form, even if I try to do Retrieve Value for Control on the other form's field and try to put it into a textbox in the form I am trying to get the value too.

Any pointers will be greatly appreciated.

dataobjx

Posts: 181

Posted: 07/29/2004, 8:58 AM

Perhaps a silly question, but have your tried to use;

Dim sResult
sResult = Request.Form("txtTextBoxName")
_________________
www.DataObjx.net
www.mydigitalapps.com

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login