Prev: The disappearing form
Next: Form opening to new record
From: Melinda on 26 Apr 2010 10:38
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 mcrouse(a)dot.state.oh.us
From: ruralguy via AccessMonster.com on 26 Apr 2010 11:37
This link should get you started. I would put it in the AfterUpdate event of
each control. Then if you change something it will change the default as well.

http://www.mvps.org/access/forms/frm0012.htm

Melinda wrote:
>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 mcrouse(a)dot.state.oh.us

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

From: Beetle on 26 Apr 2010 11:47
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



 | 
Pages: 1
Prev: The disappearing form
Next: Form opening to new record