A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Autofill text boxes



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2010, 03:38 PM posted to microsoft.public.access.forms
Melinda
external usenet poster
 
Posts: 178
Default 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  
Old April 26th, 2010, 04:37 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default 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  
Old April 26th, 2010, 04:47 PM posted to microsoft.public.access.forms
Beetle
external usenet poster
 
Posts: 1,254
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.