SQL Update in Access Vba runs ok - but prompts for inputboxes

[ick64]

Hello all,



By adding the code below in the afterupdate event of a field in a form I get to update the record I need.

However, instead of using the data I provided to do the update, Access prompts inputboxes for each one of the variables (i.e. Me.DataEmissao and Me.NumSolic).

SQL ="UPDATE tabSolic_Orcamento "& _
"SET tabSolic_Orcamento.DataEnvio = Me.DataEmissao "& _
"WHERE ((tabSolic_Orcamento.Código = Me.NumSolic)) "

Any tips?


Thank you!

[pbaldy]

You have to concatenate:

"SET tabSolic_Orcamento.DataEnvio = " & Me.DataEmissao & _

If the data type is text or date/time, you need the appropriate delimiters around the value (' or #).

[ick64]

Thank you pbaldy - it worked great!

Just one final issue.. I use the date in the dd/mm/yyyy format but it is passed on to the record as mm/dd/yyyy. How can I adjust the date format?

[pbaldy]

You have to format the "correct" way.

http://allenbrowne.com/ser-36.html#Format

[ick64]

Thanks again pbaldy - after checking the link, the scropt now is running perfectly!

[pbaldy]

Excellent, happy to help!