Search results

OK, I looked at the help but it wasn't quite clear, but using my example makes it seem pretty simple...I should be able to pull that off...thanks for the help...

Ian, The data is coming from an external source, but I am getting it as a CSV file and just set up the macro in excel to import it as my predecessor did. Instead of doing the Union query, which is unfamiliar to me, I am just going to go back in excel and edit the macro to bring the file in as...

I have a fairly simple table which is composed of a location on a row, and then has details from a quesionaire on the columns. Each question has a mean and a n column. So say for the cancer center I have a quesion tagged a1...so I will have an a1m and an a1n column. This is repeated for about...

When I look under the help for the IIF statement it says they can be used on forms or reports...Do they even function in criteria lines? If not why is the node portion functioning properly?

I have three levels of cascading combos Division>Admin>Department and an independent combo called node. Now I want the query to pull all the values if nothing is selected in the combo box. The node field is the only one that is working properly. My code is as follows...

Ok now I have the boxes clearing and requerying afterwards, I actually just added the me.cboadmin="" before my requery line and that works how I want. Does anyone have any insight to the IIf problem, and if it should work in the Dept box the same way it works for the Admin box...:confused:

Ok so I would have For IntCntr = 2 to 3 Me.("CboAdmin" & IntrCntr).Requery Me.("CboAdmin" & IntrCntr)="" Sorry for my ignorance but what is the IntCntr in your expression? thanks, Chad

I have three levels of fairly simple cascading combos. All contained in the same table- Division>Admin>Dept. All three boxes work fine, but now I am attempting to have them do two additional steps. 1. I want the lower levels to default to a null value upon entry into the upper levels. I...

I agree, this forum is great. I spent all day yesterday trying to figure out a cascading combo group without even knowing what it was. I stumbled onto this site at the end of the day yesterday, and by lunch todayI had them up and running. I look forward to gaining lots of usefull information...