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

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.
 
W

Warrio

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
 
B

Buddy

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.
 
Top