Question

Locked

Access forms-2007

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.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Try these out....

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.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums