Data Propagation

  • Thread starter Thread starter Michael Stengel via AccessMonster.com
  • Start date Start date
M

Michael Stengel via AccessMonster.com

I have a form with 5 fields, (field1, field2, field3, field4, field5) once
the form is filled out and record saved, I want to add a new record with a
command button, but propagate information already typed into the first 3
fields to save typing it again. Also the first field is a lookup field.
 
You may want to take a look at your database design. It is usually not
necessary to repeat the same information over and over again. You can use
the AfterUpdate event of your control (not field, that is what the data is
actually stored in, in the table) to set the default value for the next
record, without using a command button (i.e. just move to the next record or
a new record):

Me!txtBox1.DefaultValue = """" & Me!txtBox1.Value & """"

That's 4 double quotes on either side.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top