Displaying a Number entered in a previous record on a new record

[Aboone]

Hello,

I woudl like to dispaly the order number which has been entered into a previous record on a new record.

I am unable to use an autonumber as our Order number format is constantly changing with the date.

Thanks.

[Stang02GT]

Hello,

I woudl like to dispaly the order number which has been entered into a previous record on a new record.

I am unable to use an autonumber as our Order number format is constantly changing with the date.

Thanks.

Hello Aboone and welcome to TSDN!!

If i am understanding your question correctly you want to have the same order number for multiple records? I am assuming that your order number is based off of the date?

You could create a form that allows you to enter your own order numbers. This way when you are going through if the order numbers are all going to be the same for that day you can enter them in or there might be a way to code something like that in VB, although im not sure.

But let us know a little more about what you are doing that way myself or someone else will be able to assist you better :)

Good Luck!

[missinglinq]

To assign a value from a the last record entered into the next (new) record entered you have to use the control's AfterUpdate event. The exact syntax depends on the datatype of the particular field.

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
 

Welcome to TheScripts!

Linq ;0)>

[Stang02GT]

To assign a value from a the last record entered into the next (new) record entered you have to use the control's AfterUpdate event. The exact syntax depends on the datatype of the particular field.

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
 

Welcome to TheScripts!

Linq ;0)>

Linq,

Does this code work off of whatever Aboone enters? So if the 1st order id Aboone enters 1234 it will be the same for all the records until that number is changed?

[Aboone]

Hi Everyone,
Thanks so much for the help, but I am afraid I wasn't quite clear enough.

I will be entering a new order number for each record. I would simply like to be able to see the order number f(rom the last record entered) on the new record.

I hope that is a little clearer. Thank you again for your help!

[MGrowneyARSI]

you could just set a text field = to a Dlookup of the last number