View details from List Box

L

learningMikey

Hi All....I have a table with following structure:

ClientID - Autonumber
ClientCID - PK(AlphaNumeric exact six digits)
ClientName - Alpha
EngagementName - Alpha
WeeklyActivity - Memo ---(There is a lot of information that goes here and I
cannot have it as a text field. It exceeds 255 characters).

What I am trying to do is have a form with upper box as list box that gives
Client Name and Engagement Name. The bottom box is a text box that should
display the weeklyactivity when clicked on appropriate client. I have a code
that easily displays the information in list box but once I click on any of
the client I cannot see anything in text box. How can I do that? Thanks for
all your help.
 
Top