records in form view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In form view, how do you get the list box to start on the same
choice(beginning choice) for each new record, instead of having the list box
start off from the previous record's choice.
Thx
Jimmy
 
On the OnCurrent event of the form, you can put this code

Me.MyListName.Selected(0) = True

To set the list box to move to the first choice, everytime you move to a new
record
 
Jimmy Ferguson said:
In form view, how do you get the list box to start on the same
choice(beginning choice) for each new record, instead of having the list
box
start off from the previous record's choice.

If you use Ofer's suggestion, be sure you test to make certain sure that it
is a NEW record, because if you do that when displaying an existing record,
you will wipe out the value of the field that had been selected for that
record.

Larry Linson
Microsoft Access MVP
 

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

Back
Top