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 / October 2005

Tip: Looking for answers? Try searching our database.

Trouble with option groups linking to drop down lists!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Confused - 18 Oct 2005 18:42 GMT
Hi,
 I have an option group on my form with 2 option buttons.  Then I have a
combo box that I need to use to look up a current record on my form.  What I
would like to happen is that when I select the 1st option group button I need
it to link to the combo box and enable it.  An when I select the second
option group button I need the combo box to be disabled? Can this be done?

I tryed looking through the other responses and questions but none of them
seemed to help me any.  If this is a repeat question could you please direct
me the right way.

Thank you
Klatuu - 18 Oct 2005 19:40 GMT
In the After Update event of the Option Group that your buttons are in,
enable or disable the combo box:

(let's assume your options are 1 and 2, and 1 means enable the combo box and
2 means disable it:

Me.MyComboBoxNameHere.Enabled = Me.MyOptionGroupNameGoesHere = 1

> Hi,
>   I have an option group on my form with 2 option buttons.  Then I have a
[quoted text clipped - 8 lines]
>
> Thank you
Confused - 18 Oct 2005 19:59 GMT
Thank you I will try that and then I will let you know how it worked!

> In the After Update event of the Option Group that your buttons are in,
> enable or disable the combo box:
[quoted text clipped - 16 lines]
> >
> > Thank you
Confused - 18 Oct 2005 20:13 GMT
That did exactly what I needed it to do ........Thank you Very Much.

Now If I could just trouble you for one other problem I am having and can't
seem to find the answer to.  I didn't create my combo box using the wizard.
How can I get the combo box to look up a record in my table with out going
through and recreating it in a wizard?  Thanks for all your help again.

> In the After Update event of the Option Group that your buttons are in,
> enable or disable the combo box:
[quoted text clipped - 16 lines]
> >
> > Thank you
 
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.