Bound combo box on continuous form Access 2000

[wesbooks]

Hello expert,

I have a continuous form (Data Entry is Yes) with the following 2 cascading combo boxes.

1. Batch Type - Unbound, 1 column, string.
2. Doucment Type - Bound, 3 column, the bound column is 1, integer.

The value of the Document Type is dependent on the selection of the Batch Type.

The porblem:
========

When the first record is entered, the values populated on the two combo
boxes are perfect. However when the second record is entered and right after the user has selected a value from the unbound combo box, the following actions are taken by the form:

(1) the value of the unbound combo box of the first record is changed to the new value selected on the second record.
(2) the value of the 2nd combo box on the first record is disappeared.

It sounds to me that the unbound combo box only can handle one instance. Once the value of the unbound combo box is changed, the value of the correspondent unbound combo box on the whole form are changed automatically to the new value. How to set the combo box to behave correctly on continuous form?

 

[PHV]

This is standard behaviour:
in the detail section of a continuous form an unbound control has the same value for ALL records.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886