Using VB 5.0, I am having trouble with the Insert Into and Update statements when saving to the
database. I am using the following syntax ... INSERT INTO (field1, field2,...) VALUES ('" & textbox & "','" &
mskedbox1 & "'...) and I get the error : "Syntax error in insert into statement". The same happens with update. I've
narrowed the problem down to the maskedit boxes (the textboxes work fine alone). Suggestions?
I get the correct value showing when debugging. I have also tried transferring the value to a textbox and then using the textbox to save to the database with SQL....same error.
NB I posted this quesiton before, but my email address was incorrect, so I didn't get the answers ... sorry.