View Single Post
  #1  
Old February 11th, 2010, 10:10 PM posted to microsoft.public.access.forms
ondvirg via AccessMonster.com
external usenet poster
 
Posts: 8
Default Custom Zoom Form Not Updating Data

I have some code tied to the double click event for a control that opens a
custom zoom form and displays the text as well as the label of that control.
Right now, if I add to the text in the zoom form, it doesn't actually update
the data in the table. I know I've read somewhere how to accomplish this, but
my searching isn't finding it again.
The code I'm using is below. Any help would be appreciated. Thanks

Private Sub evnt_prblm_descr_txt_DblClick(Cancel As Integer)
strZoomPar = Me.name & ";" & Me.ActiveControl.name
strTitle = Me!Label16.Caption
DoCmd.OpenForm "frm_exp_txt", , , , , , strZoomPar
Forms("frm_exp_txt").Controls("text0") = Me.ActiveControl
Forms("frm_exp_txt").Controls("text5") = strTitle
End Sub

--
Message posted via http://www.accessmonster.com