Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Re: Combo Lookup problem

Discussion in 'Information Technology' started by Ted W., Jul 28, 2006.

  1. Ted W.

    Ted W.
    Expand Collapse

    I am having the exact same problem (ie the value in my combo box selector
    does not update if the next or previous record selection buttons on the form
    are used instead of selecting a value from the combo box) but your answer is
    too vague for me. Where to I put this "me.Combo1 = Null" DO i put it
    somewhere in the AfterUpdate event code? If you could please give a more
    detailed explanation of how to get the combo box to update when the record
    selector buttons are used I would be very appreciative. Thanks

    "Allen Browne" wrote:

    > You can keep the combo up to date if you use the Current event of the form,
    > and also the AfterUpdate event of the control.
    > However, the simplest solution is to clear the combo after the record is
    > found, e.g.:
    > Me.Combo1 = Null
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    > "Scooby" <Scooby@discussions.microsoft.com> wrote in message
    > news:E6E8B368-AC65-4FE2-9A7E-E8F8423290A7@microsoft.com...
    > >I have created a form that lists members information, I have added a combo
    > > box that is used as a 'search' facility. This works fine and when I select
    > > a
    > > members name then their relevant information is shown. However if the user
    > > then decides to abandon the search facility and browse the records via the
    > > stand previous and next records button then the name currently in the
    > > combo
    > > box remains the same and choose not change when the record does.
    > >
    > > Is there a way of making sure it changes. I know there probably is a
    > > simple
    > > answer to this but I cant seem to find it.

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page