Text box value based on query(?)

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I posted this in the New Users section, but it looks like
it would have been better to ask my question here. For
those of you who read both, I apologize for the
repetition.

I have a form (frmContactInfo), for faculty information,
in which there is a subform (fsubKeywordMatch), which
captures keyword IDs that faculty select from a set list
(lists keyword IDs and keyword descriptions for viewing
only).
What I would like to do is create a text box that will
display the keyword description based on the keyword ID
that is entered into the KeywordID control on the
subform, so the user can verify that he entered an
appropriate keyword ID. KeywordID and KeywordDescription
are separate fields in another table (tblKeywordsAll),
and I have a simple parameter query based on that table
(qryKeywordDescription), which uses the keyword ID as the
criteria to display the related keyword description.

How do I put this together? My understanding of code is
equivalent to See Spot Run, so any help you can give
would be appreciated.

Thanks!
 
Back
Top