Repeat the data from previous records

[mathanraj76]

I current doing a project for "CWS" invoices for data entry in ms access 2000
I have a diffulcuties in the textbox.

for an exampe :
In one invoices may have up to 4 customer .But in 1 invoice the route and date are same and rest is are not same ..

So i have create textboxes to entry all the data in ..
what i want if the date and route is same i dont want to key in the same data where the textbox should retrieve the data automaticaly only for date and route textbox

can u help me how to do this?
I have been try so many sites but still did not get what i need!

thanks
M raj

[ADezii]

I current doing a project for "CWS" invoices for data entry in ms access 2000
I have a diffulcuties in the textbox.

for an exampe :
In one invoices may have up to 4 customer .But in 1 invoice the route and date are same and rest is are not same ..

So i have create textboxes to entry all the data in ..
what i want if the date and route is same i dont want to key in the same data where the textbox should retrieve the data automaticaly only for date and route textbox

can u help me how to do this?
I have been try so many sites but still did not get what i need!

thanks
M raj

Just a little clarification M raj.

1. You are entering a New Record.
2. If the Date and Route are the same as the previously entered Record.
3. Duplicate some Field values on the Form from the prior Record.
4. If all this is true, then:
   1. What is your Table Name (Record Source for the Form)?
   2. What are the Text Field Names for the Route and Date Fields?
   3. What Fields need to contain the same information from the previous Record, give Route and Date are the same?

[AaronMor]

Just a little clarification M raj.

1. You are entering a New Record.
2. If the Date and Route are the same as the previously entered Record.
3. Duplicate some Field values on the Form from the prior Record.
4. If all this is true, then:
   1. What is your Table Name (Record Source for the Form)?
   2. What are the Text Field Names for the Route and Date Fields?
   3. What Fields need to contain the same information from the previous Record, give Route and Date are the same?

I am trying to do the exact same thing that you have both descriibed here. Can anyone please explain how to accomplish this? Thanks

Aaron

[missinglinq]

You can do this by using the AfterUpdate event of the controls in question to set the Default Value for those fields. The exact code varies depending on the data type of the 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)>

[ahalf0rd]

You can do this by using the AfterUpdate event of the controls in question to set the Default Value for those fields. The exact code varies depending on the data type of the 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)>

Hi Linq

I am having problems deciphering which bits of your code need my personal database details and which are just code. Could you please be a little more specific about which bits of the code need my details.

cheers

Andy