Cascading Combo boxes

J

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.
 
A

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.
 
Top