Entering a new record on a subform

B

Bobk

I have form I use in a receiving department. The form brings up a purchase
order, the purchase order header data and the line items contained in the
purchase order. Below that I have another subform showing receipts by
lineitem. In some instances a partial receipt has been received. In these
cases more than one instance of a receipt may be displayed. The last record
showing is a blank record where additional receipts would be entered. When
the subform is first displayed the first record is automatically selected. I
added a "new" button which forces the new empty record to be selected. I
expected the first field in the record to be selected based on the tab order
I set up, but it doesn't. To get to the correct field, I have to use a mouse
to select it. Even tabbing has no effect. Is there some additional code I can
add to the "new" button that would get me to the field? Also, when I finally
get to the field and enter data, such as the number one, I get 10 in the
field. I set the default to "", but the same thing happens. What is the trick
to controlling data entry? Also, when I enter data in the first field another
blank record pops up under the one I am working on. Is there a way to
suppress this action until I have competed entering data in the current field
I am working on?
 
Top