Date/Query problem...

[Wulf13]

I have an unbound text box with a medium date input mask.

In the afterupdate event of this box I have it run an append query. This query appends several pieces of data and I'd like it to pull the date from this unbound textbox.

Yet it doesn't. If I format the textbox as standard text it will recognize the value, with the input mask, it doesn't pull anything. This tells me that I need to use some sort of conversion somewhere along the line. Can someone point me in the right direction?

 

[Wulf13]

thanks but got it...

Just used CDate() function and it worked like a champ, it only took 4 days and 8 reference books but...dang it, I found it.

 

[WayneRyan]

Wulf,

Just out of curiosity, How did you reference the TextBox?

Plus, it only took you 47 minutes, that's not bad.

Wayne

 

[Wulf13]

Sorry it took so long

This is the field that pulls the text value from my form and then converts it to a date...

RTDDate: CDate(forms!masterListQ.OffPRPsubform!DATE)

Of course I'm sure there is a better way to do this but this worked for me.