Question Locked

Access forms-2007

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by Former member

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.

This discussion is closed to new replies.