Forwarding currency to next record

[Balmora via AccessMonster.com]

Ok thanks for all your help in advance, i have found with some help that if
you right

Private Sub datatotal_AfterUpdate()
With Me.datatotal
.DefaultValue = .Value
End With
End Sub

in vb, it will send the number to the next record in datatotal that is good
and i have also found that if you right

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = Me.datatotal.Value
End If
End Sub

in vb, it will send the number to the next reccord but to a difrent field in
this case datatotal would be send to data1 in the next record that is cool
but the problem is that the moment i use a value with decimals like 21.50 it
wont transfer in the field i will find #Name? , what can i do with all the
rest of my code all is fine

 

[Klatuu]

Check the data type of the field bound to data1
My guess is it is not a single, double, or currency.

 

[Balmora via AccessMonster.com]

Check the data type of the field bound to data1
My guess is it is not a single, double, or currency.

Ok thanks for all your help in advance, i have found with some help that if
you right

[quoted text clipped - 19 lines]

wont transfer in the field i will find #Name? , what can i do with all the
rest of my code all is fine

I checked and the data type for data1 is currency thanks any ways

 

[Balmora via AccessMonster.com]

Any more ideas, anyone ????

 

[Douglas J. Steele]

Works fine for me.

 

[Linq Adams via AccessMonster.com]

I had no problem doing it either! Corruption of some kind?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Balmora via AccessMonster.com]

I had no problem doing it either! Corruption of some kind?

Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog

 

[Balmora via AccessMonster.com]

Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog

I just did it again, it works when i use a hole number like 30.00$ and if i
enter a number like 30.50$ i get #Name? y?

 

[Balmora via AccessMonster.com]

Can you tell me what you have done exactly, because a have tryed it in a new
data base and still does not work, i have no clue to what im doing wrog

I just did it again, it works when i use a hole number like 30.00$ and if i
enter a number like 30.50$ i get #Name? y?

 

[Balmora via AccessMonster.com]

Ok thanks for all your help in advance, i have found with some help that if
you right

Private Sub datatotal_AfterUpdate()
With Me.datatotal
.DefaultValue = .Value
End With
End Sub

in vb, it will send the number to the next record in datatotal that is good
and i have also found that if you right

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = Me.datatotal.Value
End If
End Sub

in vb, it will send the number to the next reccord but to a difrent field in
this case datatotal would be send to data1 in the next record that is cool
but the problem is that the moment i use a value with decimals like 21.50 it
wont transfer in the field i will find #Name? , what can i do with all the
rest of my code all is fine

Well thank you guys for all your help, i found out what to do i will show you
just so you know and help anyone how has the same problem

Private Sub datatotal_AfterUpdate()
If Not IsNull(Me.datatotal) Then
Me.data1.DefaultValue = """" & Me.datatotal.Value & """"
End If
End Sub

Cool hop it can help!