Automatic field population

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

Guest

My database uses several forms which use drop-down lists to populate a
specific field. Depending on how the drop-down list is configured for a
particular table, as I use it in the form, it may show two of the columns of
the associated table, but enter only one of the columns (the first one) in
the form's field to be populated. As an example, I have a table containing
two variables, billing codes (ICD9) and a description of the code
(ICD9Description). In the form where this table is used in a drop-down, both
columns will show (ICD9 & ICD9Description), but only one of the columns will
populate the field (ICD9). Is there a way to have both of the columns
populated in the form, perhaps in two separate fields? I really need both
pieces of information to show in the form in order to avoid repeatedly typing
it in.
 
No need to save the Description... you have the ICD9 value, so you can
always "display" the associated Description in any subsequent form or query
or report.

Just use a text control with a ControlSource of...
= cboYourComboName.Column(1)
to display the Description column of your combo.

hth
Al Camp
 
Al,

Thanks for your input. However, I guess I'm still fairly "new" at
programming, and am not exactly sure what you mean in your response. Could
you possibly refer me to info on "text controls" and "control sources"? I
have the Access 2003 Bible, and haven't found the these topics yet (at least
as you describe). Until then, I'll keep looking.

Thanks.

Reep

AlCamp said:
No need to save the Description... you have the ICD9 value, so you can
always "display" the associated Description in any subsequent form or query
or report.

Just use a text control with a ControlSource of...
= cboYourComboName.Column(1)
to display the Description column of your combo.

hth
Al Camp
Click to expand...
 
Back
Top