Repeated Data

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

Guest

In the membership database for our organization, there's a field for State.
Almost all our members are from New York. Can I set that field to "NY" by
default, then change it for those few members who are from out of state?
 
Sure. Just enter the state in the "default value" in the property box for
your control on your form.
 
In the membership database for our organization, there's a field for State.
Almost all our members are from New York. Can I set that field to "NY" by
default, then change it for those few members who are from out of state?
Click to expand...

Sure. Just open the table in design view, and select the State field. Look in
the field properties window on the lower left; type

NY

in the Default Value property.

John W. Vinson [MVP]
 
Back
Top