Turn Default Property On/Off

  • Thread starter Thread starter Karen H. via AccessMonster.com
  • Start date Start date
K

Karen H. via AccessMonster.com

I have a data entry form. A lot of the time the same information is being
entered on the 2nd, 3rd, etc data entry record with a few variations. Is
there a way to add a button or Menu a way to turn the default replication of
the previous record on if need? I think the default for opening the form is
not to replicate the previous record, but if the user know they are entering
several similar records, they can turn it on somehow.


Thanks,

Karen
 
One of the options provided by the wizard when adding a command button to a
form is RecordOperations>Duplicate Record.
 
I have a data entry form. A lot of the time the same information is being
entered on the 2nd, 3rd, etc data entry record with a few variations. Is
there a way to add a button or Menu a way to turn the default replication of
the previous record on if need? I think the default for opening the form is
not to replicate the previous record, but if the user know they are entering
several similar records, they can turn it on somehow.
Click to expand...

One way to handle this is, for each control that you wish to
automatically duplicate, to set its DefaultValue property in its
AfterUpdate event:

Private Sub txtFieldname_AfterUpdate()
Me!txtFieldName.DefaultValue = Chr(34) & Me!txtFieldName & Chr(34)
End Sub

This could be made a bit more sophisticated - say have an unbound
checkbox chkDup on the form, and check its value prior to setting the
DefaultValue property.

John W. Vinson[MVP]
 
Back
Top