putting data automatically in memo field

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

Guest

I have a table with 2 fields, an "ID" and "description" field. The
description field is a memo (there is no lookup feature in a memo field). The
id field has a combo box lookup which gets its data from a list on another
table.This list includes the id and descriptions. I want to be able to
automatically update the "description" memo field when I select data from the
combo in the"id" field with the corresponding description.
 
Why are you storing the information in two places? If you tables are
designed correctly, this would be unnecessary.
 
The reason for the "list" table is it holds several lists of different names
and their codes eg "project"; "Project code" "Prospect" " Prospect Code" etc.
I then have several tables that these codes are entered using combo boxes
into the respective records on the various tables along with other data such
as sample details; assays etc.
I would appreciate some constructive help, not just someone telling me I'm
stupid.
Kerry
 
in the onchange event of the combo

depending on you combo box

me.memofieldname = me.comboname.column(1) ' col # depends on how
many cols there are and which it is bound to
or
me.memofieldname = me.comboname
 
I have been reminded that the afterupdate event might be a better place
to put the code, rather than the onchange.
 
Back
Top