Combo Box always selecting first record

[geet72]

Hi

I have two tables - Policy Details and Policy limits Details with one to many relationship between policy details ans policy limits. I have created a form with policy details as main form and policy limits details as sub form. I have a combo box in policy limits details sub form that shows values based on selection in a combo box in policy details main form.

The problem comes when I select any value in the combo box in policy limits details subforms, only the first value in the combo box is selected. Can you please help. Trying to figure this out for two hours

Regards

 

[Soulium]

Do you mean you want to see the other values in the combo box e.g.

UserID, UserName.

And you only want to show UserName?

 

[geet72]

Hi

Let me explain a little more.

Table1 - Policy Type Table - Policy Type No and Policy Type name (1 - General, 2 - Automobile)

Table 2 - Policy Type Sub Table - Policy Type No, Policy Type Sub Type (General -Aggregate Limits, General - Excess Liability, General - Sabotage)

The Policy Details table has a field - Policy Type No which comes from the Policy Type table. (Ex. General Insurance, Workers Compensation etc). The Policy Limits table gets the Policy Type Sub type from the Policy Type Sub type table. The combo drop down is limited to the value of the Policy Type No. When I select a value in the Policy Sub Type combo box always the first value is selected and not any other value.

Please help

 

[geet72]

I have rephrased the question. Can some one help

"Table1 - Policy Type Table - Policy Type No and Policy Type name (1 - General, 2 - Automobile)

Table 2 - Policy Type Sub Table - Policy Type No, Policy Type Sub Type (General -Aggregate Limits, General - Excess Liability, General - Sabotage, Automobile - Bodily injury, Automobile - Comprehensive)

Table 1 and 2 are linked by Policy No and have one to many relationship

Table 3 - Policy Details (Policy No, company, POLICY TYPE NO from table 1, etc)

Table 4 - Policy Limits Details (Policy No, POLICY TYPE NO, POLICY SUB TYPE from table 2 etc)

table 3 and table 4 are linked with one to mant relationship

I have created a form to populate table 3 and table 4.

Table 3 is main form and table 4 is sub form.

The sub form has a combo box for the policy sub type which is limited to the values of the policy type. So if General is selected as policy type, only aggregate limits, excess liability and sabotage show up in the drop down.

However, if I select sabotage, only the first record - aggregate is always selected.

Can you please help with this. I have been struggling for a week