"General" activecontrol.dropdown function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MarkD - 13 Jan 2005 01:39 GMT

Using Access2000.

I have a form with a bunch of dropdowns. I know I can add
the Me.activecontrol.dropdown event to each dropdown event
(on the GotFocus event or something), but I was wondering
if there was an "general event" that fires whenever the
user moves from one control item to the next. That way, I
can just 1) check if the control is a combobox and 2) if
it is, run the me.activecontrol.dropdown method.

Thanks much,
-Mark

Reply to this Message

PC Datasheet - 13 Jan 2005 04:09 GMT

Add the following sub to your form:
Sub CbxDropDown()
Me.activecontrol.dropdown
End Sub

Hold the ShiftKey down and select all the comboboxes. Open properties and go
to the Events tab. Type the following into the Enter event:
= CbxDropDown()

Each of your comboboxes will now drop down when you enter the combobox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> Using Access2000.
>
[quoted text clipped - 8 lines]
> Thanks much,
> -Mark

Reply to this Message

MarkD - 14 Jan 2005 21:51 GMT

Hi,

Thanks for your reply. Wroks great, except I had to use =
[CbxDropDown]

-Mark

>-----Original Message-----
>Add the following sub to your form:
[quoted text clipped - 28 lines]
>
>.

Reply to this Message

PC Datasheet - 14 Jan 2005 23:25 GMT

Hi Mark,

Check my response again - I had the equal sign! :)

Steve
PC Datasheet

> Hi,
>
[quoted text clipped - 46 lines]
> >
> >.

Reply to this Message