Software

Question

Gravatar
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

gravatar
Collapse -

Try these out....

by Peconet Tietokoneet-217038187993258194678069903632 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.

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

Start or search

Related Discussions

Related Forums