Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / November 2007

Tip: Looking for answers? Try searching our database.

Change event missing from Forms 2.0 combo box.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Billy Smith - 12 Nov 2007 03:41 GMT
I'm doing a project in Access 2000 using forms and MS Forms 2.0 combo
boxes.  I'm not using the native Access combo box because it lacks an
Add Item method and is therefor very difficult to populate.

I want to do something when the user makes a selection in the combo box
so I need to respond to the Change event.  The object browser shows a
number of events including Click and Change available for the combo box.
However, these events do not appear in property list of the combo box
so I cannot get to them.

I have confirmed that I'm using the Forms 2.0 combo box and not the native
one (both the object browser and the OLE class property of the combo box
say so).

Something else really strange is that a week or so ago in the same
project file I made a form with this same kind of combo box and the
Change event was available.  The code is there and it works.  Now,
even if I add another Forms 2.0 combo box to the form I made last week,
the change event is missing.

I've also confirmed that about 15 properties like Match Entry and Style
are set as they are in the combo box from last week's form just in case
the Change event is somehow available only for a certain combination
of properties.  But that does not help.

Any ideas of why these events are missing or a workaround?  It's beginning
to look like a bug to me.  Thanks in advance.

--Billy
Douglas J. Steele - 12 Nov 2007 12:17 GMT
Just because the Events don't show up in the Properties dialog doesn't
usually matter (although I must admit that I don't use the Forms controls).
In the VB Editor, if you choose the combo box from the list at the top left
of the module, does the Change event show up in the list at the top right of
the module?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I'm doing a project in Access 2000 using forms and MS Forms 2.0 combo
> boxes.  I'm not using the native Access combo box because it lacks an
[quoted text clipped - 25 lines]
>
> --Billy
Billy Smith - 12 Nov 2007 13:52 GMT
Doug,

Yup, the Change event is in that list.  And when I double click on it VB
generates the proper event handler stub code and that solves my problem.
I don't think I ever created an event handler that way but now I will.
Live and learn.

Thanks for your help.

--Billy

> Just because the Events don't show up in the Properties dialog doesn't
> usually matter (although I must admit that I don't use the Forms
[quoted text clipped - 33 lines]
>>
>> --Billy
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.