passing unbound value to append query (1 Viewer)

[Wulf13]

When I have my form I have an unbound control called rtdDate. In rtdDate's AfterUpdateEvent I have it run a append query. Within the append query I have the following:

RTD Date: forms!masterListQ!rtdDate

Yet it keeps coming up blank when you run the query. Its like its not finding the value of it. I'm sure you can tell I'm pretty much an amateur at database building but I thought this would be pretty easy.

What am I doing wrong?

 

[Wulf13]

Update

If I format the unbound with an input mask for medium date it won't pass the value to the query. Yet if I format it as a text box it will pass text. I need it to pass the date.

 

[Wulf13]

anybody???

 

[Malcy]

Just a stab, but what are the property settings for the field in the table that you are appending TO? If it is not set as a date field then I do not think it would append the contents of the text box correctly.
Might be wrong though!

 

[rpfisher]

I have the same problem as this - still trying to find the answer.
I have checked the settings of the field I am appending to and it is definitely date format.
I can pick up the text but not the dates.
Any answers welcome!