I have a question about this exercise. In the exercise you have to create a boolean variable and set the default value to True. As you continue, once you bind the data to the combo box, you set the value of the boolean variable to False. Why is it that when I go to the SelectedValueChanged event of my comboBox, the code will not work unless I have some kind of If statement on top? It shouldn't whether I have that variable or not, the code should still work. I'm I missing something about the SelectedValueChanged event that I should be aware of?

When you bind the combobox, the SelectedValueChange event is fired. If you do not have the If statement as the first code in your ComboBox1_SelectedValueChanged procedure, the rest of the code will be executed and an execption will be thrown because no data will have been loaded at this point. Try commenting out the If statement at the top of this procedure to see what I talking about.

Thearon

Yes, I saw that before, but I just don't seem to understand why the data wont load unless I have the "IF" stament there, when I have told the data to bind to the combo box in my previous Sub procedure.

Because the SelectedValueChange event is being fired when you perform the binding.

Thearon

Hi all, I have coded exercise 2 exactly but when I populate the ComboBox I get this error message:
"Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)."
on this line of code:
[
'Add the required parameter for the query
objCommand.Parameters.Add("@ProjectID", OleDbType.Guid, 16).Value = _
New Guid(cb1.SelectedValue.ToString)]

Anyone know what I'm doing wrong?

Thanks