append with date from txtbox

T

Troy

I have a append table query. I have one field reserved for a date that I
would like to pull from a text box. How can I record the date from this
text box on my form to the table when it's append?

TIA!
 
J

John Vinson

I have a append table query. I have one field reserved for a date that I
would like to pull from a text box. How can I record the date from this
text box on my form to the table when it's append?

TIA!
Click to expand...

CDate([Forms]![YourFormName]![YourTextboxName])

as a calculated field in the append query should do the trick.

John W. Vinson[MVP]
 
Top