Fill text box based on combo box selection

[peasedm@gmail.com]

Okay this one has me stumped. I have a table called Review_Statemen ts
with the following columns:

statementid
type
statement1
statement2
statement3

I have a form called SR_Review with an unbound combo box control
(rationale_type ) that is based on the statementid and type field of
the table above.

I also have another text box control on the same SR_Review form called
rationale. This field is bound to field called "rationale" in another
table called SR_Reviews.

Here is what I *want* to take place. The user makes a selection in the
rationale_type combo box, and based on the statementid of their
choice: combine statement1, currentuser, statement2 and statement3 for
that same statementid in the rationale text box (so it's stored in the
rationale field of the SR_Review table). i.e., me.rationale=st atement1
& currentuser & statement2 & statement3 where
review_statemen ts.statementid = me.rationale_ty pe

I can't for the life of me figure out how to do this in vb code. Can
anyone help get me started?

The reason I need to break up the paragraph or statement this way is
that I need to track exactly who made the selection - I have to
somehow get the currentuser into this paragraph and it's the only way
I could think of. If you have any other wise ideas that I hadn't
thought of I'd be happy to hear.

Deena

[peasedm@gmail.com]

Re: Fill text box based on combo box selection

Duh - I figured this out so please ignore.