-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
If you want the default to carry over to the next opening of the form
you have to save the control's default setting. One way is to save the
settings into a table - use the forms Unload event procedure.
CREATE TABLE DefaultSettings (
FormName Text(255) Not Null ,
ControlName Text(255) Not Null ,
DefaultValue Text(255) Not Null ,
CONSTRAINT PK_DefaultSettings PRIMARY KEY (FormName,ControlName)
)
When the form opens load the default settings into the controls
..DefaultValue property from the table.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQkNgIoechKqOuFEgEQKVrwCaA3hogRQvsKVwDv+r9ryX5O n7SwgAnjaP
UUdwS0JJPcpGZVDsgdU3Er+7
=qLXz
-----END PGP SIGNATURE-----
DSmith wrote:
No, it didn't. It only works while the form is opened.
"DSmith" <Do***@nospamres-xraynews.com> wrote in message
news:UD*******************@bignews5.bellsouth.net. ..
Thank you, that worked.
"MGFoster" <me@privacy.com> wrote in message
news:gx****************@newsread1.news.pas.earth link.net...
DSmith wrote:
Is it possible to make whatever is inputted the default value of a
field
until a different value is inputted?
See this article:
http://www.mvps.org/access/forms/frm0012.htm
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)