n Thu, 9 Sep 2004 11:59:29 +0200, Bernd Smits wrote:
If you wish the form to open on double-clicking the combo box, then
place the code to open the form in the Combo Box's Double-click event,
not the click event.
You could pass the opening position to the form using the OpenForm
DoCmd.OpenForm "FormName", , , , , , Me!ComboName.Left & "," &
Me.ComboName.Top + Me!ComboName.Height + Me.FormHeader.Height + 1440
You'll need to adjust the above, depending upon if you have a form
header and exactly where you wish the form to open.
Note: The measurements are in Twips; 1440 Twips = 1 inch.
Then code the Load event of the form being opened:
If Not IsNull(Me.OpenArgs) Then
DoCmd.MoveSize Left(Me.OpenArgs, InStr(Me.OpenArgs, ",") - 1),
Mid(Me.OpenArgs, InStr(Me.OpenArgs, ",") + 1)
You'll also want to set this form's PopUp property to Yes.
I'm not wholly sure of what you want here.
The above is normal combo box behavior if you set the combo AutoExpand
property to Yes.
Or do you also wish to set the combo box to dropdown on enter. In that
case, code the Combo Box Enter event:
Please only reply to this newsgroup.
I do not reply to personal email.