[AccessD] Add new record + fill fields with last entered data?

Gustav Brock gustav at cactus.dk
Thu Apr 1 09:06:22 CST 2004


Hi Tina

>> I begin to understand.  At the OnCurrent Event for the Form, the Event
>> Procedure will set the DefaultValue of each TextBox to the values 
>> determined to already be stored in the record just saved.  Is that 
>> correct?

> Yes and no. No saving needs to take place:

> At the OnCurrent Event for the Form, the Event Procedure will set the
> DefaultValue of each TextBox (or ComboBox etc.) to the values for the
> current record of those controls.

Well, of course, if you wish to use the recently saved values as
default values (a very common situation) every time a new record has
been added; then you would use the AfterUpdate event of the form.

/gustav


>>>>How does one set the DefautlValue at OnCurrent?  I don't know how to do
>>>>that.
>>>
>>>That's not difficult - something like this:
>>>
>>>  Dim txt As TextBox
>>>  Set txt = Me!txtYourTextBox
>>>
>>>  txt.DefaultValue = txt.Value
>>>
>>>  Set txt = Nothing
>>>
>>>However, DefaultValue should be a string which means that if your
>>>textbox contains decimals or a date/time value you must be careful and
>>>convert to a string in US format:
>>>
>>>  txt.DefaultValue = LTrim(Str(txt.Value))
>>>
>>>or
>>>
>>>  txt.DefaultValue = _
>>>    Format(txt.Value, "\#mm\/dd\/yyyy hh\:nn\:ss AM/PM\#")
>>>
>>>/gustav
>>>
>>>>>Tough day? No coffee?
>>>>>
>>>>>Set the DefaultValue at OnCurrent.
>>>>>
>>>>>As for Stuart's note on the KeyPreview, it's not a user feature, but a
>>>>>property of the form.
>>>>>
>>>>>/gustav
>>>>>      
>>>>>>when a user clicks the 'Add new record' button (s)he wants the data of the current record to be displayed in the new record.
>>>>>>So if a user is on record 999 with field username filled with AAA and then clicks on 'Add new record' then a new record (1000) must appear with the field username filled with AAA.




More information about the AccessD mailing list