Is there a straight forward way in a subform, which is a continuous form, to
autofill as you fill the form out.

On the subform I have a StateStockNo, Quantity, PricePerUnit, Unit, Line
Cost, Descripton. I would like the StateStockNo, PricePerUnit, and Unit, to
autofill as I begin the next row in the subform and only have to change the
Quantity and it would make the calculation. Would look as follows

888888 20 2.20 ea Asphalt
$44.00
(autofill) 10 (autofill) (autofill) (autofill)
(makes the new calc.)

And then within the subform it totals the entire Cost of the accumulative
lines. For the time being I have them using their "Ctrl ' but I thought I
would take the time to place an autofill in there . Thanks so much.

Reply to (E-Mail Removed)

You may find this link helpful;

http://allenbrowne.com/ser-24.html

BTW - it is a bad idea to post your real email address in
a public newsgroup like this, as they are regularly checked
by spammers fishing for email addresses. You may soon
notice an increase in the amount of spam you receive.

--
_________

Sean Bailey