auto-fill, set carry to, set carry on etc

[vw]

Not sure of easiest way to set up a form for this. Need
to repeat info in certain fields and don't want to have
to re-key each time. DBase had a 'set carry on' command
which did this. Is there a simple command that I can use
in a query on my table before keying in forms for the
specific fields or an easy way to set up in forms?

 

[Allen Browne]

Access does not do this natively, but you can achieve it a couple of ways.

Option 1. Set the Default Value of each control in its AfterUpdate event
http://www.mvps.org/access/forms/frm0012.htm

Option 2. Use the BeforeInsert event of the form to drop in the values:
http://members.iinet.net.au/~allenbrowne/ser-24.html