InfoPath Dev

Thanks! Worked like a charm! 

Thanks Clay!  I am not sure that this is going to work for me. I can't do the submitted option way because i am submitting my form to a document library so the rules button is disabled in that menu. We're on the right track, i just need another way? Any more ideas? 

I have a control on my InfoPath 2007 form that I want disabled when the user is filling it out, but enabled after the form has been submitted so that is can be modified by another user. Any ideas on how this can  be done? SPD32177 

For example, I have an SQL 2005 database with a table called states. Within that table two columns, all 50 states in one and their counties in the next (this may or may not be the best way of going about this). On my form, I want the user to be able to select their state in one dropdown and then have another dropdown update itself with the ...