Combobox Display confusing

When someone selects an item from a combo box, the curser jumps to the
record selected. It is then possible to scroll to the next or previous
record. But the combobox still shows the originally selected item. Is it
possible to clear the combobox when the item no longer matches the item
selected? It just looks confusing. Or even better, make the combobox scroll
with the current records.

Annelie

On Sun, 13 Jun 2004 14:49:37 -0400, Annelie wrote:

When someone selects an item from a combo box, the curser jumps to the
record selected. It is then possible to scroll to the next or previous
record. But the combobox still shows the originally selected item. Is it
possible to clear the combobox when the item no longer matches the item
selected? It just looks confusing. Or even better, make the combobox scroll
with the current records.

Annelie

Add one line of code at the end of the Combo Box event (AfterUpdate)
or in the Form's Current event:
Me![ComboName] = ""


--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

It is better to synchronise the ComboBox with the current Record.

In the Form_Current Event, use something like:

Me.ComboBox = Me.RecordID

RecordID should be the Bound Column of your ComboBox.

--
HTH
Van T. Dinh
MVP (Access)




"Annelie" wrote in message
...
When someone selects an item from a combo box, the curser jumps to the
record selected. It is then possible to scroll to the next or previous
record. But the combobox still shows the originally selected item. Is it
possible to clear the combobox when the item no longer matches the item
selected? It just looks confusing. Or even better, make the combobox
scroll
with the current records.

Annelie

Thanks to both of you,
I got Fred's suggestion to work but the other one, my program did not like.
I could not get the form to go back to forms view. Perhaps I didn't do it
correctly.
Annelie

"Annelie" wrote in message
...
When someone selects an item from a combo box, the curser jumps to the
record selected. It is then possible to scroll to the next or previous
record. But the combobox still shows the originally selected item. Is it
possible to clear the combobox when the item no longer matches the item
selected? It just looks confusing. Or even better, make the combobox
scroll
with the current records.

Annelie

I went at it again today, because I did not like what I got when the
combobox completely cleared. So I tried Van's suggestion again and I did it
right putting into the Forms_Current Event and now the selection scrolls
right with the rest of the form. Cool
Annelie

"Van T. Dinh" wrote in message
...
It is better to synchronise the ComboBox with the current Record.

In the Form_Current Event, use something like:

Me.ComboBox = Me.RecordID

RecordID should be the Bound Column of your ComboBox.

--
HTH
Van T. Dinh
MVP (Access)




"Annelie" wrote in message
...
When someone selects an item from a combo box, the curser jumps to the
record selected. It is then possible to scroll to the next or previous
record. But the combobox still shows the originally selected item. Is it
possible to clear the combobox when the item no longer matches the item
selected? It just looks confusing. Or even better, make the combobox
scroll
with the current records.

Annelie