If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Combobox Display confusing
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. |
#3
|
|||
|
|||
Combobox Display confusing
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 |
#4
|
|||
|
|||
Combobox Display confusing
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 |
#5
|
|||
|
|||
Combobox Display confusing
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 |
Thread Tools | |
Display Modes | |
|
|