Results 1 to 3 of 3
  1. #1
    alpinegroove is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Jan 2011
    Posts
    114

    Keeping Currency Field Null in New Record in Subform

    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.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    As answered elsewhere, likely either the textbox or field in the table has a default value of 0.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    alpinegroove is offline Competent Performer
    Windows XP Access 2002
    Join Date
    Jan 2011
    Posts
    114
    Thanks again

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-07-2011, 02:51 AM
  2. Replies: 7
    Last Post: 07-15-2011, 01:58 PM
  3. Replies: 2
    Last Post: 03-23-2011, 11:43 AM
  4. Replies: 3
    Last Post: 01-15-2011, 02:39 AM
  5. Memo Field Not Keeping Data
    By maintt in forum Forms
    Replies: 1
    Last Post: 08-12-2010, 05:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums