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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Maria said:
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.
Click to expand...


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.
 
Marshall Barton said:
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.
Click to expand...
 
Back
Top