"General" activecontrol.dropdown function?

M

MarkD

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
 
P

PC Datasheet

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.
 
P

PC Datasheet

Hi Mark,

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

Steve
PC Datasheet


MarkD said:
Hi,

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

-Mark
-----Original Message-----
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
(e-mail address removed)
www.pcdatasheet.com





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top