Recent content by Astronomyman

  1. A

    Default field on a Form

    Function: Public Function GetDefaultFEE() As Currency GetDefaultFEE = Nz(DLookup([DateNumber], [tblSubscriptionTable]), Month(Date)) End Function Field on form: Default Value =GetDefaultFEE Response: #Name? Should the field be enclosed in parentheses? I don't understand what I am doing wrong...
  2. A

    Default field on a Form

    "I wonder about this table too. Why do you need any more than the Month number and fee." The table is used elsewhere to populate Queries
  3. A

    Default field on a Form

    I want to fill a default value on a form field using a function that displays the membership fee based on the current month (which is pro-rata) I have a table with the month number and fee [tblSubscriptionTable]: SubscriptionID SubscriptionMonth SubscriptionAmmount DateNumber 2 Jul £20.00...
  4. A

    New Member

    Hello all. My name is Tony and I have been working with Access for the past six months; my goal is to build a database for Astronomy Club Membership. I thought I would try your forum for this question as I know many of the knowledgeable experts visit this forum to give assistance I'm getting...
See more
Top Bottom