Auto-Filling a Text box based on Multiple Boxes
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.