Filling data from a previous record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am entering a large database where often the data does not change from one
record to the next. How can I prevent having to retype this and copy from the
previous record as I need to?
 
Set the DefaultValue property of each control with each data entry.
Something like (aircode):

Sub MyControl_AfterUpdate()
Me.MyControl.DefaultValue = """" & Me.MyControl.Value & """"
End Sub

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