If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill text boxes
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 |
#2
|
|||
|
|||
Autofill text boxes
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 -- 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/For...forms/201004/1 |
#3
|
|||
|
|||
Autofill text boxes
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 |
Thread Tools | |
Display Modes | |
|
|