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 / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

combo

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maran - 21 Jan 2008 16:39 GMT
have placed a subform, which gives the Price. It is based on the Query. I
have given a criteria in the query like [forms]![mainform]![productid].



So, when I select a product from a combo box, on the main form, I should see
the price on the subform. The problem, is it does not refresh. It still shows
the same price for the earlier product. But, when I move, it gets refreshed.



Can I have a code , so that I should see the price as soon as I select the
product from the combo box .
Jackie L - 21 Jan 2008 17:37 GMT
On the After Update event of your combo box put the following:

[Forms]![frmMainForm]![sfrmSubformName].Requery

Hope this helps,
Jackie

>  have placed a subform, which gives the Price. It is based on the Query. I
> have given a criteria in the query like [forms]![mainform]![productid].
[quoted text clipped - 13 lines]
>
>  
 
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



©2009 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.