putting data automatically in memo field

[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.

 

[G. Vaught]

Why are you storing the information in two places? If you tables are
designed correctly, this would be unnecessary.

 

[Guest]

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

 

[Ron2006]

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

 

[Ron2006]

I have been reminded that the afterupdate event might be a better place
to put the code, rather than the onchange.

 

[Guest]

Ron2006,
This worked a treat. Thank you.
Kerry

 

[Ngoc]

t?t