J
Janna
I have a table that contains detailed descriptions. The table has two
fields, an identifier field (id) and then one longer memo field (descrip).
I have a form that’s based on a separate table and in this form I would like
to have a lookup field or combo box that can look up the id value from the
description table and then pre-fill a separate field on my form(SumOfProj)
with the contents of the descrip field. I would also like to have the
flexibility to add more text in the SumOfProj field if necessary. I suspect
there is an elegant way to do this in VB code, but lack the programming
experience. What might be the best way to accomplish the above? Thank you.
fields, an identifier field (id) and then one longer memo field (descrip).
I have a form that’s based on a separate table and in this form I would like
to have a lookup field or combo box that can look up the id value from the
description table and then pre-fill a separate field on my form(SumOfProj)
with the contents of the descrip field. I would also like to have the
flexibility to add more text in the SumOfProj field if necessary. I suspect
there is an elegant way to do this in VB code, but lack the programming
experience. What might be the best way to accomplish the above? Thank you.