Keeping Currency Field Null in New Record in Subform

alpinegroove

Registered User.
Local time
Today, 07:44
Joined
May 4, 2011
Messages
55
I have a form linked to a regular table and a subform linked to a junction table.
The subform has four fields, 3 combo boxes, and the currency field for manual data entry.

The subform is set a Continuous Form.

When I use the subform to create a new record, the currency field gets automatically populated with $0.00 as soon as I make a selection using the combo box in the subform. I can manually delete it, but I don't want it to appear automatically.

How do I prevent the $0.00 from being added? I need the field to remain blank until I make an entry.

Thank you.

 
My guess is that either the textbox or the field in the table has a default value of 0.
 
You are correct. Thanks for the tip. So simple...I embarrassed.
 

Users who are viewing this thread

Back
Top Bottom