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 Programming / April 2005

Tip: Looking for answers? Try searching our database.

Value with Record change

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karen53 - 26 Apr 2005 23:08 GMT
Hi,

I have cbo_I and cbo_2 on the same form.  cbo_1 is fed off of a table.  
cbo_2 is fed off of a query that has cbo_1 set as the filter criteria.  So
the options in cbo_2 will change depending on the value selected in cbo_1.  
My problem is that if the cbo_1 value already exists, it is not filtering.  
It only filters if I make a current selection.

The criteria in my query is [Forms]![frm_A]![cbo_1]

I believe I need a way to execute a requery when I click the navigation
buttons or change the current record.  Is there a way to do this?

Thanks
Al Camp - 27 Apr 2005 01:33 GMT
Karen,
  There's several ways... you may get multiple suggestions.

  Try using the OnCurrent event of the form
If Not IsNull(cbo_1) Then
   cbo_2.Requery
End If

   If cbo_1 is empty you don't have to requery since you'll have to enter a
value in cbo_1 anyway.  You would then use the AfterUpdate of cbo_1 could
trigger that requery.

hth
Al Camp

> Hi,
>
[quoted text clipped - 10 lines]
>
> Thanks
Karen53 - 27 Apr 2005 23:39 GMT
Thanks!  

> Karen,
>    There's several ways... you may get multiple suggestions.
[quoted text clipped - 25 lines]
> >
> > Thanks
 
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.