TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • August 12, 2008 at 4:01 am #2152974

    Access forms-2007

    Locked

    by srinidhi_sesh · about 14 years, 10 months ago

    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.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Answers

  • Author
    Replies
    • August 12, 2008 at 4:01 am #2929908

      Clarifications

      by srinidhi_sesh · about 14 years, 10 months ago

      In reply to Access forms-2007

      Clarifications

    • August 12, 2008 at 4:19 am #2929906

      Try these out….

      by Anonymous · about 14 years, 10 months ago

      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.

  • Author
    Replies
Viewing 1 reply thread