Auto Populate Field from form.

[Antony Elson]

Hi,

I have a form that has two combo boxes, combo box one is
bound to a table with a list of TOSERVICE in field 1 and
descriptions in field 2. Combo box two uses the following
code as its control "=[TOSERVICE].[Column](1)".

When using the form I select combo box 1, this supplies
me with a list of TOSERVICE codes and the description,
the TOSERVICE code is then added to the bound table.

The description is then shown on the form in combo 2, but
it does not add the description to the table.

Is there any way that I can have it so the description is
also added to the table that combo 1 is bound to?

 

[Steve Schapel]

Antony,

Do I understand you correctly? Do you mean that each TOSERVICE code is
associated with only one Description? And that this is already entered
into the table which serves as the Row Source for Combobox 1? If so, I
don't understand why you have a Combobox 2, as there are no choices to
make anyway, so a Textbox with the same Control Source
=[TOSERVICE].[Column](1) would serve the purpose. And, it would not
really be valid to try to save the Description into the second table.
Easiest solution is to simply delete the Description field from the
second table altogether, and look up the Description in the first table
whenever you need it for your purposes on form or report.