update/delete fails because of null checks

[jimatqsi]

Hi. Long time Access programmer just getting started with Visual Studio and ASP.Net. Using VS 2005 with VB language.

Using the walk through help pages, I can easily make working web pages that pull data from my Access database. Way cool! :) Until, I try to update my data. :(

When I enable editing and deleting I can still view my data. I can click the Edit button and change my data, but when I click the "Update" button after I have changed the data, I get this error. And I get the same error when I click the "delete" button. The error is:
"No value given for one or more required parameters."

I can get rid of the error if I change

UpdateCommand="UPDATE [FD_GROUP] SET [FdGrp_Desc] = ? WHERE (([FdGrp_CD] = ?) OR ([FdGrp_CD] IS NULL AND ? IS NULL)) AND (([FdGrp_Desc] = ?) OR ([FdGrp_Desc] IS NULL AND ? IS NULL))">

to

UpdateCommand="UPDATE [FD_GROUP] SET [FdGrp_Desc] = ? WHERE (([FdGrp_CD] = ?) OR) AND (([FdGrp_Desc] = ?) OR )">

What's going on and how do I avoid this problem?

Thanks,
Jim