Question

  • Creator
    Topic
  • #2152974

    Access forms-2007

    Locked

    by srinidhi_sesh ·

    Hello everybody,

    I am using Access 2007 version and in my form I am using a label box with underlined option and click event and if I enter a single policy number(which I enter using the first form)and click the policy num it navigates to the third form and if I click one number from a list of policy numbers it goes to the third form but it does not display any records. Why? Any help in this will be much appreciable.
    Thanking u.

All Answers

  • Author
    Replies
    • #2929908

      Clarifications

      by srinidhi_sesh ·

      In reply to Access forms-2007

      Clarifications

    • #2929906

      Try these out….

      by Anonymous ·

      In reply to Access forms-2007

      You should have a table of policy numbers attributable to each condition:

      tluConditions
      ConditionID (Primary Key Autonumber)
      Condition

      tluConditionPolicies
      ConditionPolicyID (PK autonumber)
      ConditionID (Foreign Key)
      PolicyNumber

      From there, you can have a combo that choses a Condition, then fill a textbox with all policy numbers that meet that condition.
      http://databases.about.com/od/tutorials/ss/access2007forms.htm

      Please post back if you have any more problems or questions.

Viewing 1 reply thread