Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

forms and subforms

Status
Not open for further replies.

abenitez77

IS-IT--Management
Oct 18, 2007
147
US
I have a form (emailviewer) and a subform (emailviewer subform) and on my form, I have a field (txt_message). In my subform I have a field called message. I have multiple records in the subform (using continuos forms). When I click on a record, I want to populate the field (txtbox) on my form with the value of the subform field (message). How can i do this?
 
Put in the fields click event

me.parent.txt_Message = me.message
 
I get the error msg "The expression On Click you entered as the event property setting produced the following error: Method or data member not found.

This is my syntax:
Me.frm_EmailViewer.txt_message = Me.Message
 
Probably because that is not what I suggested. I wrote:
me.parent.txt_Message = me.message

Why not try that?
 
Thanks...that worked but when i tabbed all the way thru to the next record it did not update the text box. I tried putting this in the textbox (=[frm_EmailViewer subform].Form!message) and that worked whether I clicked on the record or tabbed all the way to the next record.

Thanks for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top