By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Form and a Listbox

P: n/a
I have a form that is linked to a listbox. The listbox contains a list from
A to Z, lets say. When I click on 'B' the form goes to that record, no
problem. If I click in the form on the txtbox that is bound to the listbox
and scroll with the mouse wheel or search for records that way, it does not
change the highlighted record in the listbox, but does change the records on
the form. How do I get the listbox to change to the appropriate record when
I browse in the form as well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 6 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
If I'm reading this right, I don't see why you couldn't use a combobox
with the LimitToList property set to True and the AutoExpand property
to True. Wouldn't that achieve the same thing? You can choose
multiple values from a listbox, but if you're not using that, there's
almost no reason, in my mind, to use a listbox. They definitely have
their place, but I'm not sure this is one of them.

Sep 6 '06 #2

P: n/a
In the On Current event of the form update the list box with the relevant
identifier of the record.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au

"kallen via AccessMonster.com" <u6724@uwewrote in message
news:65e5f9667325f@uwe...
>I have a form that is linked to a listbox. The listbox contains a list
from
A to Z, lets say. When I click on 'B' the form goes to that record, no
problem. If I click in the form on the txtbox that is bound to the
listbox
and scroll with the mouse wheel or search for records that way, it does
not
change the highlighted record in the listbox, but does change the records
on
the form. How do I get the listbox to change to the appropriate record
when
I browse in the form as well?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 7 '06 #3

P: n/a
Thanks Jeff.
It was quite simple, really. It works perfect.

Jeff wrote:
>In the On Current event of the form update the list box with the relevant
identifier of the record.

Jeff Pritchard
________________
Asken Research Pty. Ltd.
Access Database Developers
http://www.asken.com.au
>>I have a form that is linked to a listbox. The listbox contains a list
from
[quoted text clipped - 8 lines]
>when
I browse in the form as well?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

Sep 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.