Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004
    Posts
    115

    Unanswered: Default value in a tabular form.

    In my tabular form, I want the DEFAULT value for the bounded Text
    Box txtNeedBy, to be the same as YearsTo20.

    Every record will have a different figure.
    I can't set the control source to "= [YearsTo20]" cause some fields
    have to be changed.

    How can this be done?
    Will creating an Update Query help?

    Please see the attached sample. (Self explained)

    I hope, I provided enough clarifications on this question.

    2. I also have realized that when opening this form, the first record
    will always have a 0, even you change it manually.


    3. is there any way to eliminate the last blank record?
    I'm not planning to add new record in this form.

    Thanks
    Tom
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •