 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2008how to update combo box Problem
Greeting, I have a form for adding new info. There is a combo box for initial of employees. And there is a command button for open a form that allows to input new initials. I put the following code in the main form with on current event to update the combo box value Private Sub Form_Current() Me.CD_REP.Requery End Sub Where the "CD_Rep" is the combo box The code is working fine and I could add data but when I close the form of Initials and reopen it and add more initial, the new initials do not appear unless closing the form and reopen it. Can any body help me please? > Greeting, > [quoted text clipped - 14 lines] > > Can any body help me please? There is a "requery" action that you can do. I cannot remember exactly how/where, but a search on that might yield some fruit. Hi Mike I tried but there is no fruit > > Greeting, > > [quoted text clipped - 17 lines] > There is a "requery" action that you can do. I cannot remember exactly > how/where, but a search on that might yield some fruit. How are you filling the combo box? If you are using a macro to open the form on the command button then add the requery after the form open part of the macro and see if that has the desired effect. Adrian >> Greeting, >> [quoted text clipped - 21 lines] > There is a "requery" action that you can do. I cannot remember exactly > how/where, but a search on that might yield some fruit. Thank you Adrian, it Works > How are you filling the combo box? If you are using a macro to open the > form on the command button then add the requery after the form open part of [quoted text clipped - 27 lines] > > There is a "requery" action that you can do. I cannot remember exactly > > how/where, but a search on that might yield some fruit. |
Reply to this Message |
 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.