Form field not printing

[flap14]

Hi
I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and the value is there to see. When I go to print the form (paper or PDF) the delivery fee returns to zero (the database entry is still present). No idea...help please

 

[bob fitz]

Is the "delivery fee" control on your form bound to a field in a table.

 

[spikepl]

Don't print forms: they were not made for printing. Print reports. You most likely need to save the record before you print.

 

[flap14]

Bob
Yes, the delivery fee is in the Order line table upon which the subform is based

 

[bob fitz]

Have you read post #3 from spikepl. I would agree with all the comments made there.

 

[flap14]

I do agree with that post but I still don't understand why this is happening. Basically the currency value is there on the screen and in the relevant table, it just doesn't appear once printed. I've checked the 'display when' field in the property sheet but that's fine.
Any ideas would be most gratefully received

 

[flap14]

Actually, have just created a report to mimic the form and the same thing is happening. I've double-checked the table and the field is set to Currency and the default value is 0

 

[bob fitz]

Is the record being saved before printing takes place.

 

[flap14]

I am indeed, the field remains containing a value on screen but with a value of 0 in print preview, pdf and on paper
:banghead:

 

[bob fitz]

How are you printing

 

[spikepl]

If the default 0 is shown in the report, then the printing is OK.

HOW exactly do you save the record prior to printing?

 

[patinchuot1]

I'm interested in this subject, thank you for sharing ...