Hello-
I have a combo box whose rowsource is set to an SQL statement. The SQL is SELECT Count..., so it returns a value and places it as the ItemData(0) in my combo box. I then need to use this value in an UPDATE SQL statement. Everything works fine until my SELECT statement returns no values (based on my criteria). Obviously this Null causes problems for my UPDATE query.
Is there an If statement that will change my combo.ListCount from 0 to 1 and then set Combo.ItemData(0) to 0? I've tried the Nz() everywhere I can think of and it's not working.
Thanks!
I have a combo box whose rowsource is set to an SQL statement. The SQL is SELECT Count..., so it returns a value and places it as the ItemData(0) in my combo box. I then need to use this value in an UPDATE SQL statement. Everything works fine until my SELECT statement returns no values (based on my criteria). Obviously this Null causes problems for my UPDATE query.
Is there an If statement that will change my combo.ListCount from 0 to 1 and then set Combo.ItemData(0) to 0? I've tried the Nz() everywhere I can think of and it's not working.
Thanks!
