Unanswered: Data Type Conversion on All Date Fields
I'm very new to Access and VBA so I'm sure this is probably a simple fix but I can't seem to figure it out. I have a rather large database with multiple forms that record dates when investigations and assignments are completed. There are multiple dates as the assignment progresses and the managers approve it. The problem I'm having is I can't save anything unless all the dates are filled in. I keep getting a Data Type Conversion Error until the date fields all have something in them. The forms are unbound and I've programmed everything with VBA. Any help would be greatly appreciated. Thanks.
PS. I've checked to make sure data types on the tables and the forms match up.
Does anyone have any idea why this is happening?? Upon further investigation it seems like it's any of the fields that are set to numbers or dates. I was able to enter the following code but it's not going to work if someone edits a record and deletes information in a field that previously had data in it. Any help would be greatly appreciated.
If IsNull(tbxOpendate) = false Then
rst!OpenDate = tbxOpenDate