bro simple ra kaau imong problem,data type mismatch jud na kay imong date kay as datetime anag data type, then the way you save it you used txtdate.text, sayop na cya bro, dapat ing ani ay
# " & txtdate.value & " # i try ni bro or kung dili gani ni magwork try erase your fields sad, dretso na insert into tablename values( values niya). i hope it could help bro