combodata flow from query to form field, not to the table ,help!

[Guest]

Several form fields are based to a combo box. In that way,
it will automatically update the next as shown below. When I type-in the
name the rest will be updated.
NAME: SSN: UNIT: DAS:
(Field 1) (field 2) (field 3) (field 4)
This is what I used as for the equation under control source in the
property:
NAME SSN: =Form!name.column(1)
UNIT: =Form!name.column(2) DAS: =Form!name.column(3)

This works somehow but there's a problem. The data flows from the query
to the form field with no problem but it does not update the TABLE or the
REPORTS. Is there anyone know how to force the update?
Is there another way to get the data based on combo box from query to
the form field, table and report? I would really appreciate your help.
Thank you.

 

[Marshall Barton]

Several form fields are based to a combo box. In that way,
it will automatically update the next as shown below. When I type-in the
name the rest will be updated.
NAME: SSN: UNIT: DAS:
(Field 1) (field 2) (field 3) (field 4)
This is what I used as for the equation under control source in the
property:
NAME SSN: =Form!name.column(1)
UNIT: =Form!name.column(2) DAS: =Form!name.column(3)

This works somehow but there's a problem. The data flows from the query
to the form field with no problem but it does not update the TABLE or the
REPORTS. Is there anyone know how to force the update?
Is there another way to get the data based on combo box from query to
the form field, table and report? I would really appreciate your help.

In general, you do not want the values to be save to a
table. That would be redundant data that may become
inconsistent in some circumstances.

To get the data in a report or other situations, create a
query that joins the form's table to the combo box's table
so you can use both sets of dtat in the report.

 

[Guest]

In general, you do not want the values to be save to a
table. That would be redundant data that may become
inconsistent in some circumstances.

To get the data in a report or other situations, create a
query that joins the form's table to the combo box's table
so you can use both sets of dtat in the report.