Bound combo box on continuous form Access 2000

[Guest]

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?

 

[Marshall Barton]

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?

That is the way unbound controls work on a contunuous form.
There is no error and your data is fine, it's only the
appearance that's annoying. You might want to consider
binding the batch combo box to a (new?) field in the table.

The issue of the document value disappearing on some other
records is explainable and well known. However the
workaround is messy as it requires that you place a text box
exactly on top of the combo box's text portion. The text
box needs to be bound to a field (in the form's record
source query) that joins to the combo box's row source table
to get the display text. You would also need to use some
code in the text box's GotFocus event to switch the focus to
the combo box.