October 29, 200124 yr Newbies Here's the problem You can pick up to 10 restaurants from a preselected list of 40 restuarants and/or fill in your own from 10 tezt boxes. So you could select all 10 from the preselected ones, or select 5 preselected ones and fill in 5, or simply fill in all 10. I have 40 checkbox fields (named chk1, chk2, chk3...) for the pre-selected ones and 10 text fields (named box1, box2, box3...) I use Javascript to make sure no more than 10 are selected/entered from both sets. I have a calculated field (rest10) that basically goes through each to see if the field isblank or not. If not, it adds Restaurant name otherwise it adds nothing. The problem is if I go back to the web entry page (which shows you which ones your previously selected) and unselect any check boxes, they still show up in the calculated results. If I select a new checkbox, it is appended to the end of the calculated field. So if I had previously selected A, B & C, the results look like A, B, C but if I go back and unselect A and select E, the results look like A, B, C, E Why is the previous calculated results not being over written after a new submission?
Create an account or sign in to comment