Comments by The-guy-on-the-couch

The-guy-on-the-couch 10-Jul-19 5:26am View

FranzBe thank you for your assistance, I finally got around to trying the above method, however when I submit the data, VS returns an "Exception unhandled" System.ArgumentNullException: 'Value cannot be null.
Parameter name: key' at the line

If tableDictionary.TryGetValue(ComboBox2.SelectedValue, theTableName) Then

Unfortunatley I'm uncertain as to what value this could be, please could you advise?

The-guy-on-the-couch 8-Jul-19 9:19am View

Cheers, I will give it a try. Hopefully I will get this thing working. I really don't know how developers can do this stuff all day. I suppose it helps if you know exactly what you're doing. Thanks again, I'll let you know the outcome.

The-guy-on-the-couch 8-Jul-19 8:38am View

Thanks for offering your assistance, I tried completing the If Else statement and it producded the same dialog "command text not set". As for the solultion below, I tried the "switch" method however that produces a BC32017 error - Comma, `)`, or a valid expression continuation expected. Removing the $"\"{ComboBox2.SelectedText}\ from the argument clears the error, but I then get an exception unhandled event when I submit the data.

The-guy-on-the-couch 8-Jul-19 6:23am View

Using access 2003. Sorry about that, I copied the text and forgot to paste the rest. I get no errors in VS, however when I try to submit, I get a dialog that says "command text not set for the command object".

Comments by The-guy-on-the-couch (Top 4 by date)