-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Not exactly. You'd have to write some VBA code.
There's one method that is quite common: set the default property of a
control so it uses the last entered value as the new default. When a
new record is accessed the default value automatically fills the
controls' values property.
Usually, a toggle button is set next to the control. When it is
depressed (toggle = true) then the .Default is set to the .Value. When
the toggle is up (toggle = false) then the .Default setting is set to
nothing.
=== air code ===
Private Sub txtControlName_AfterUpdate()
If Me!txtToggle_ControlName = True Then
If Not IsNull(Me!txtControlName) Then
Me!txtControlName.Default = Me!txtControlName.Value
Else
Me!txtControlName.Default = ""
End If
Else
Me!txtControlName.Default = ""
End If
End Sub
=== end air code ===
I believe there is an article about this in the _Access Developer's
Handbook_, by K.Getz, et. al.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA+AwUBQRk28IechKqOuFEgEQLOuACYk/VJXGr0m34oxpl9thvdxldT7wCdG28e
eSKjDwuQbi6faqvRIpbC6vY=
=+Klh
-----END PGP SIGNATURE-----
tangel wrote:
There may be a simple anwswer to this....
I have a client who's accustomed to entering his data into an Excel
spreadsheet. He has a lot of repetitive or sequential data, and he
likes using the Excel fill tool to drag down a column to fill in the
cells for him.
The question is, is it possible to do something similar to this in
Access?
