Cascading Combo boxes

[Jules]

Hi
I have a "continuous" sub-form which contains 3 combo boxes and 1 unbound
text box.

Combo box #1 requeries Combobox #2 and Combox#2 requeries Combox#3. The
unbound text box contains the following code: =[combobox#3].column(1).

The problem is that once combox #2 requeries Combox#3 in a new line, all
previous values held in the unbound textbox disappears.
I would like to know how to display the users previous choices in the
unbound text box...Any and all help is most appreciated!!!
Giuliano C.

 

[Allen Browne]

An unbound text box is incapable of displaying different values on different
rows of a continuous form or datasheet. You might solve the problem by
adding the lookup field to the form's source.

1. Create a query that contains both the table that feeds the form and also
the table that feeds the combo.

2. If the combo's field is not required, double-click the line joining the 2
tables in query design. Access pops up a box offering 3 choices. Choose the
one that says:
All records from the form's table, and any matches from the combo's.

3. Drag the asterisk from the form's table into the query's output grid, and
also the text field from the combo's table. Save the query.

4. Open the form in design view, and set its RecordSource property to the
new query.

5. Set the Control Source of your text field to the text field you added to
the query.

The text field will now show the value from the combo's table on each row of
the form.

 

[Rick Brandt]

Hi
I have a "continuous" sub-form which contains 3 combo boxes and 1
unbound text box.

Combo box #1 requeries Combobox #2 and Combox#2 requeries Combox#3.
The unbound text box contains the following code:
=[combobox#3].column(1).

The problem is that once combox #2 requeries Combox#3 in a new line,
all previous values held in the unbound textbox disappears.
I would like to know how to display the users previous choices in the
unbound text box...Any and all help is most appreciated!!!
Giuliano C.

An unbound TextBox will always appear the same in all the rows of a
continuous form. There really is only one control that is painted multiple
times. The only thing that varies from row to row is the bound data.