Same Data for the previous record

[ElTipo]

Hello!

I need to know how I can maintain the same data of the previous record to the new record.

For example:

In record 1. My input is a date for 7/1/07 but I need this same date in record 2.

How I can do this!

Thanks for any answer.

[missinglinq]

By setting the deafult for a control to the last value entered for it. The exact syntax varies with the datatype.

For Text fields

Private Sub YourTextControlName_AfterUpdate()
If Not IsNull(Me.YourTextControlName.Value) Then
  YourTextControlName.DefaultValue = """" & Me.YourTextControlName.Value & """"
End If
End Sub
 

For Numeric fields

Private Sub YourNumericControlName_AfterUpdate()
If Not IsNull(Me.YourNumericControlName.Value) Then
  YourNumericControlName.DefaultValue = Me.YourNumericControlName.Value
End If
End Sub

For Date fields

Private Sub YourDateControlName_AfterUpdate()
If Not IsNull(Me.YourDateControlName.Value) Then
  YourDateControlName.DefaultValue ="#" &  Me.YourDateControlName & "#"
End If
End Sub
 

Linq ;0)>

[ElTipo]

By setting the deafult for a control to the last value entered for it. The exact syntax varies with the datatype.

For Text fields

Private Sub YourTextControlName_AfterUpdate()
If Not IsNull(Me.YourTextControlName.Value) Then
  YourTextControlName.DefaultValue = """" & Me.YourTextControlName.Value & """"
End If
End Sub
 

For Numeric fields

Private Sub YourNumericControlName_AfterUpdate()
If Not IsNull(Me.YourNumericControlName.Value) Then
  YourNumericControlName.DefaultValue = Me.YourNumericControlName.Value
End If
End Sub

For Date fields

Private Sub YourDateControlName_AfterUpdate()
If Not IsNull(Me.YourDateControlName.Value) Then
  YourDateControlName.DefaultValue ="#" &  Me.YourDateControlName & "#"
End If
End Sub
 

Linq ;0)>

Thanks for your time Ling

Ok I write the 3rd code because is a date filed but the form it's for data entry and this property is in Yes. The tap key in the keyboard clear the record for proceed to the new entry.

It's affect this code this property in YES for the form?

[Scott Price]

Thanks for your time Ling

Ok I write the 3rd code because is a date filed but the form it's for data entry and this property is in Yes. The tap key in the keyboard clear the record for proceed to the new entry.

It's affect this code this property in YES for the form?

Buenos Noches, El Tipo!

This code will go in the afterupdate event of your form's control that accepts the date value. The tab key that you use to go from one record to another will then NOT clear the data for the next record.

For example, if you have a form in continuous form view, you will enter the date in a text box named something like txtDate. Put this code in the afterupdate event of the txtDate control, changing the names to reflect the name of your control (Me.txtDate)

If you need an explanation in spanish let me know!

Regards,
Scott

[ElTipo]

Buenos Noches, El Tipo!

This code will go in the afterupdate event of your form's control that accepts the date value. The tab key that you use to go from one record to another will then NOT clear the data for the next record.

For example, if you have a form in continuous form view, you will enter the date in a text box named something like txtDate. Put this code in the afterupdate event of the txtDate control, changing the names to reflect the name of your control (Me.txtDate)

If you need an explanation in spanish let me know!

Regards,
Scott

Gracias Scott, Thanks for your time again.

Perdona el inconveniente lo que sucedio fue que coloque el codigo en el control y no en la forma. Es por esto que no funciono correctamente.

Agradezco a Ling por su ayuda y también a ti por la atención.

Tremendo "Site" mucho exito Scott.

[Scott Price]

Gracias Scott, Thanks for your time again.

Perdona el inconveniente lo que sucedio fue que coloque el codigo en el control y no en la forma. Es por esto que no funciono correctamente.

Agradezco a Ling por su ayuda y también a ti por la atención.

Tremendo "Site" mucho exito Scott.

Bueno! Si está funcionando bién, que bueno... De nada por todo.

trans:

Excuse the inconvenience, what happened is that I put the code in the control and not in the form. That's why it wasn't working correctly.

Thank you linq for your help also, and Scott for your attention.

Tremendous Site! Wishing you all success, Scott

Good! If it's working for you, that's great! You're welcome for all.

Regards,
Scott