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 / March 2008

Tip: Looking for answers? Try searching our database.

after update event

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
scubadiver - 12 Mar 2008 14:39 GMT
hello,

I have two combos.

When the first combo is changed from "pending" to "live" I want the second
combo to become enabled.

I have the following in the after update event.

If Me.StatusID.Value = "Live" Then Me.MonthID.Enabled = True

but it isnt working.

It has been awhile...
Klatuu - 12 Mar 2008 15:06 GMT
You also have to requery the second combo

   If Me.StatusID.Value = "Live" Then
       Me.MonthID.Enabled = True
       Me.MonthID.Requery
   End If

Note: Single line coding is poor form.
Signature

Dave Hargis, Microsoft Access MVP

> hello,
>
[quoted text clipped - 10 lines]
>
> It has been awhile...
scubadiver - 12 Mar 2008 15:33 GMT
It doesn't work. I should have mentioned the form is continuous. Would that
complicate things?

> You also have to requery the second combo
>
[quoted text clipped - 19 lines]
> >
> > It has been awhile...
Klatuu - 12 Mar 2008 16:15 GMT
Yes, but since I seldom use continuous forms, I don't know that I can help.
Signature

Dave Hargis, Microsoft Access MVP

> It doesn't work. I should have mentioned the form is continuous. Would that
> complicate things?
[quoted text clipped - 22 lines]
> > >
> > > It has been awhile...
 
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.