help navigating a form

hi. I have an ACCESS 2003 DB, where i have created a form in which one
of the fields is a drop down box (list box). This drop down box list
contains over 200 names and is a bit cumbersome to get to the name i
want. Is there anyways i can use my down arrow button on my keyboard to
navigate to the next name in my list? Whenever i try using my down
arrow key,even with the field active all it does is jump me down to the
box in my form.

Also, when i open the form, is there anyway to get it to default to a
'new record' rather than opening up and always showing the first
record?

thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Do you have Auto Expand property set to yes? Then, if you start typing it will move to that next record. Also if you click the down arrow (or the F4 key when that field has the focus) then you can use the down arrow or the page down keys. It just has to have the drop down already showing.

As far as going to a new record upon opening, on your On Open event of the form (Event procedure) put:
DoCmd.GoToRecord , , acNewRec



----- jaberwocky wrote: -----


hi. I have an ACCESS 2003 DB, where i have created a form in which one
of the fields is a drop down box (list box). This drop down box list
contains over 200 names and is a bit cumbersome to get to the name i
want. Is there anyways i can use my down arrow button on my keyboard to
navigate to the next name in my list? Whenever i try using my down
arrow key,even with the field active all it does is jump me down to the
box in my form.

Also, when i open the form, is there anyway to get it to default to a
'new record' rather than opening up and always showing the first
record?

thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/