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.
Click to expand...

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