Probably one of the easiest questions - but not for me :(

  • Thread starter Thread starter JasonS
  • Start date Start date
J

JasonS

Good morning!
Please, can anybody tell me how to do this?
I have a form bound to table. Lets's say that I'm inputing some data to an
editbox in this form, then I'm saving this record. Then I create new record,
and I want the value of my editbox which I input previously to be repeated
in the same editbox in new record.
I want to do it programmatically instead of using keyboard shortcuts.
I know that there once was an article regarding this issue on Microsoft's
online help, but now I can't find this link..... :(
Any help will be HIGHLY appreciated :)
Have a nice day!
 
In the AfterUpdate event of the control, set the control's DefaultValue to
the current value of the control.

Example:
http://www.mvps.org/access/forms/frm0012.htm

The example assumes a text value. If the value is numeric you won't need the
quotes. If the value is a date, you need date delimiters instead of quotes.
The date delimiter is a #.

Example:
Me.txtMyTextbox.DefaultValue = "#" & Me.txtMyTextbox & "#"
 
Back
Top