List Box (first record info selected auto...why?)

  • Thread starter Thread starter Buddy
  • Start date Start date
B

Buddy

I have a few list boxs' and when I open my form which has them (i have the
form automatically goto a new record) the list boxs' are set to the choices
that were made in my first record of data instead of "----------".

Each list box references a query where the data is sorted acending which
would put the "----------" first in order. Can anyone tell me how to make
my form reset to the default data and not that of my first record?

Thanks.

Hope you can follow.
 
The action of goToNew should clear it manually, but you can do it manualy
using the code:

DoCmd.GoToNew 'Go to a new reccord
myLstBox = "" 'Clear the content of the list box
 
I tried the following as an "event procedure" and had no luck with it
working, infact the "GoToNew" wasn't even an option. I could use
"GoToRecord" but then didn't know what to do.

Thanks for trying.
 
Back
Top