Thank you it worked!
However, I get a Run-time error '94': Invalid use of Null. This occurs when nothing has been selected yet in the combo box. When I click debug, "cValue = c.Value" is highlighted. Could I make it so when nothing is selected and I click the advance button, it goes to first record? and when I click previous button it goes to the last?
Also, Is there any way I could make it so that the advance...
Aviqq
Last Activity: Jun 8 '23, 04:51 PM
Joined: Apr 27 '23
Location:
-
Command button to go to previous record in an Unbound combo box
Hi,
I have an unbound combo box that I would like to navigate back and forth through the records populated in the combo box. I currently have an advance button thanks to this post here: https://bytes.com/topic/access/answers/649962-advancing-unbound-combo-box. Does anyone know how to do the opposite and create an previous record VBA code?
This is the code I am using for my advance:
...Code:Function AdvanceCombo(strForm
-
Do you have a code for doing the opossite? I would like to go to previous record rather than advance.
Also, If the combobox is null, is there anyway to go to the first record in the combobox rather than an error popping up? Currently I get Run-time error '94' Invalid use of Null. This also occurs when there is no more selections available in the combobox. Could the selections wrap around back to the begging? Thank you.Leave a comment:
No activity results to display
Leave a comment: