Forms, copying certain fields from current record to new record

[blackte]

I have a data entry form, that has siz fields that I would like to carry from one dataentry sheet to the next. This information is the same for the user when in this form. Is there a way to carry these fields. It seems that when I press the add record button, all fields are cleared, and that is fine for most, but these six I would like to keep until the form is close. thanks in advance for any help.

Thanks Travis

 

[JoeMiller]

In the AfterUpdate event you can change Default Value property of the selected controls to what you need:

MyTextBox.DefaultValue = MyTextBox

Then the user will always get the last record they worked on values set as the default value for the next record.

Alternatively, you can use the DLast() function to go the the query supplying the form data and look up the value last used. Set the DefaultValue property of the controls in question to look up the last value entered in their respective field like this:

DLast("[MyField]","MyQuery&quot

I prefer the second method myself, but it requires that the query being referenced be sorted in the same order as the form.

HTH Joe Miller
joe.miller@flotech.net