Welcome to SPN

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

Sign Up Now!

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...     Become a Supporter      ::     Make a Contribution     

Share This Page