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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top