2 controls to make 1 control

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

Access 2002...
I have a "Manuf" control and a "Model" control on a form.
I have a 3rd control called "Device" on the same form. I
want Device to be [Manuf]&" "&[Model] but it just won't
work for me. If I change the control source to that code
it works but then "Device" doesn't show up on the table or
reports tied to it.
Help.
Greta
 
"Device" is a calculated field in the form, and Access does not directly
support calculations in table fields. If you absolutely must have "Device"
stored in a table for some strange reason, make your calculated field in the
form an unbound field with a different name from "Device". Then add the
"Device field to your form. In the unbound field which performs the
calculation add an AfterUpdate SetValue macro to set the value of "Device"
in the table equal to the result of the unbound field's calc.

It really makes more sense to base your form on a query that includes the
"Device" calculation and display that field in the form. Then you have the
calculation in the query, form & report. No need for it to be in the table.

Con Giacomini
 
Back
Top