2 form help

[prose7777]

Hi,

I have 2 forms in this example.

Form one i enter data and click a command button to calculate other fields in the form. Under the code in Form one i send and retrive data from form one. I use Form 2 like a storage base. When i send data with decimals over to form 2. It is rounded up before it gets there.

Example

number = 2.22222
Forms!Form2!Field1 = number

Any Suggestions

 

[WayneRyan]

Prose,

It sounds like either the subform control doesn't have the
appropriate format for decimal places, or if it is a bound field
then the underlying table might be set to integer.

Wayne