Hi apr pillai Hey that is cool that you made that. Nice site too.
Just wondering if what you made will work from subforms and from subforms nested in subforms. And will it work even when the text box is empty before open the zoom? And if the user clicks in the textbox and edits it a little...
Well Thanks for all the help. I figured it out anyway.
In the case of controls on subforms, on the action event that triggers the opening of the zoom form I used this.
Me.Refresh
If Nz(Me.ActiveControl) = 0 Then
StrZoomText = ""
Else
StrZoomText = Me.ActiveControl
End If
StrZoomControl =...
Ok well, I finally figured it out. I had to add a 4th public string variable called StrOpenSubForm
Then (in the case of controls on subforms) on the action event that triggers the opening of the zoom form code the following.
StrZoomText = Me.ActiveControl
StrZoomControl = Me.ActiveControl.Name...
First let me say thanks a lot for such clear and concise directions. I was able to get this working perfectly despite the fact that I have no idea what I'm doing. I had to dig around online a bit to figure out exactly how to create the public string variables but it wasn't to hard to find that...
Hello,
I hope some of you can help me out getting this to work. I would be very grateful. Please bear with me though because this is all new to me, I have no basis to understand some of the instructions posted previously.
Ok, you've already lost me (though I think I grasp the rest of the...