Re: Combo Lookup problem

#1 (**permalink**) 28-Jul-2006, 08:42 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14040-re-combo-lookup-problem.html

"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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14040
>
> --
> 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" 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.
>
>
>