By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Fill text box based on combo box selection

P: n/a
Okay this one has me stumped. I have a table called Review_Statements
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=statement1
& currentuser & statement2 & statement3 where
review_statements.statementid = me.rationale_type

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
Mar 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Duh - I figured this out so please ignore.
Mar 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.