Help with intricate form actions - at least for me (2 Viewers)

[bhp59]

Trying to figure out a way that when a label associated with a text box is clicked, a new form with a large text box will open for data entry. Then when that form is closed it will insert the typed data into the small text box on the first form.

Also how after this is done for seven text boxes when a button is clicked the data will be posted to a table based on the check box that is checked in an option group.

Thanks - This is a great forum,
bhp59@home.com

 

[pcs]

from the 'quick & dirty' department:

is it possible that you could simply use zoom (Shift +f2) when the textbox in question has focus?

if you don't want the user to have to use this shortcut, you could do a dreaded sendkeys in the onclick of your label after setting focus to the textbox...

hth,
al




[This message has been edited by pcs (edited 07-29-2001).]

 

[Rich]

Create the following function
Function ssZm()
On Error GoTo ssZm_Err

DoCmd.RunCommand acCmdZoomBox


ssZm_Exit:
Exit Function
In the on enter event for each textbox you want zoomed add Call ssZm
HTH