Search results

Thanks CJ. I've deleted the rowsource for the result fields but suspect I need to keep the rowsource for test1-test5 since there are no rowsource set for them in VBA.

Hi CJ, Thanks! I think it's working now. A couple questions on the query... In your rowsource for some resultfields like Test1Result2a, the rowsource has the query: SELECT Description FROM tblLookups WHERE (FldGroup = 'Stress MRI' AND Col=2 AND Row =1) or Col=99 ORDER BY SortOrder; But...

Hi CJ, I went ahead and tried to redo part of the database again by starting with a completely new database to see if the problem can be fixed. In the table, I added back all of the fields and switched the appropriate ones to combo boxes. In the form, I created the tabs and added the fields...

Hi CJ, This is getting way too complicated for me :( Do you think if I started a completely new database and copied the code and layout the corruption would be fixed? In your program, test2-test5 have value choices of ECG Treadmill, Stress Echo, Stress Nuclear and CTA. But I would like them...

Hi CJ, When you say edit the value list in result2b control do you mean the rowsource in property sheet? Or do you mean the case statement? Don't I need to include all of the possible values in the rowsource because if the test is something other than "CTA" then there will be different values...

Hi CJ, Sorry for the delay in response. Didn't get any free time til now. In response to your question, yes, I am referring to the Prior tests tab but the problem exists in result2, result3, and result4. In Test1Result2b, I have 22 items, but I only want it limited to the 12, as listed in...

Hi CJ, I deleted the control fields for the original result fields on the form and added them back on and changed them to combo boxes. Here is the issue. If you select a test, say, CTA for test1, the correct values are there for Test1Result2 and Test1Result2a, but not for Test1Result2b and...

Hi CJ, I've changed all the result fields to textbox in table design mode. So doesn't this automatically get rid of the lookup list? On the form, I've then changed all the result fields to combo boxes and added the values (all possible values) in the row source on property sheet. I'm not...

Thanks CJ, that did the trick! I'm revisiting the prior tests tab again and will need to add some additional fields (i.e. Test1Result2a, Test1Result2b, Test1Result2c). I created the new columns and added it to the form as well as defined them in the code. As usual, I'm getting an error. I...

Hi CJ, I don't think I need the abstractenddate and dateofabstract to be invisible when the form appears. But yes, I was putting the line >[abstractstartdate] in the [abstractenddate] and [date of abstract] validation rule in table design mode. Any idea why the code isn't working for me? Or...

Hi CJ, The line >[abstractstartdate] gives me this errror: Invalid SQL syntax- cannot use multiple columns in a column-level CHECK constraint. But isn't this only one column?

Hi CJ, Hope you had a nice weekend! I still need to make some changes to the program. I'm now trying to validate the date fields. For example, abstract end date must be after abstract start date. I try to do this simply by table design mode and adding >"abstractenddate" in validation rule...

Thanks CJ!! It is now working like a charm! Now on to the real testing... Jim

Hi CJ, I did also add the afterUpdate subs to test3-test5 (I tried to indicate it with the ellipsis after the afterupdates for test1 and test2!) After removing the line you suggested, I still get the visibility issue. For instance, after selecting "CTA" for test1 results4 and results5...

Hi CJ, Welcome back! Hope you had a nice time traveling. I certainly am overthinking, or maybe just not thinking enough for this problem! Here is what I have. It seems to work after selecting the first test. Say, if I select "CTA" for test1, test1result4 and test1result5 is not visible...

Hi CJ, I have one other minor issue with the appearance of the program. For the Prior tests tab, when I select a number for PriorTestsCount, the result5 field does not become visible. I'm guessing it's the way the SetControls are set up for Result5 under the SetVisible Sub? Does the Result4...

Hi CJ, I think I got everything working now. Thanks for all of your help!! Can I keep you in the loop in case I have more questions later? Thx, Jim

Hi CJ, Thanks! I finally got the labels to work. I love the cheat of setting the label visible if the control is also visible. I also got the PCI/CABG tab to work. I did forget to put setVisible for the revascularization afterUpdate(). Now on to the Prior Tests tab! I think I got the...

Hi CJ, Sorry, it's not working for me. For the label under character_of_chest_pain, I selected the labels (box335, label307, label332, label333, label334) then Ctrl-X, then select character_of_chest_pain control, then Ctrl-V. Yes, it did paste it but when I go back to the form the labels are...

Hi CJ, Thanks. I got your code to work. But I am still having trouble with the label under character_of_chest_pain. I copied your code as is but it is always visible. The label was created from a textbox and does not have a related entry field. I wonder if this has anything to do with the...