In one of my databases I have a combo box (cmb1) that selects values from a table (tbl2) and then saves that value into another table (tbl1). I also have a set of five check boxes (cbx1, cbx2, cbx3, cbx4, and cbx5). What I want to do is if a user puts in a certain set of information I want another text box (txb1) to autofill with a hyperlink to a word document.
For example if they select "RPMI" in cmb1 and then check cbx1 and cbx2 I txb1 to automatically fill in the hyperlink to a certain word doucment that describes their selection more fully.
I hope that this is clear and that I can get some help. Also I am not much of a programmer at all so I kind of need it laid out. Thanks.

Well, it can be done, but how many documents do you want to link them to? How many possible combinations of 5 check boxes (120 combinations) times the combo box list? Where are you going to put the code (what event?)

There are so many possible combinations here that I am not sure how to code this. Please let me know how many possible combinations of combo box selection with check boxes there are, plus the number of word docs there are links to. It can be done, it will be a lot of code I think.

HTH


mmcdonal