Data Propagation

  • Thread starter Michael Stengel via AccessMonster.com
  • 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.
 
A

Arvin Meyer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUbform Data display order 1
how to catch values from a texts to use it as values 3
Data Entry Form/Subform? 2
Systematically add Records Through RecordsetClone 2
Multiple records per row in a continuous form 1
Form to organize records by todays date 4
SaveAs Filename:=filename, FileFormat:=xlCSV 2
How do i input a date based on value in an another access field 2

Top