Populate column in query with date from form

[cooneyge]

Hi there,
I have a Query that i need to populate every field in a column with the date. I would like to enter the date in a field from a Form but i cannot seem to get this to work.

In the Query I am using the following code in the field

End_date: [Forms].[newdate].[calen]

Where the name of the Form is newdate and calen is the field where the date is entered.

When i run this Query the End_Date name appears in the header but every field is empty. Can you help me link the form to the Query?



----
Now to add to the complexity I have 4 other files that i would like to be able to source this same date, so when i run a macro to run all Queries at once i only have to enter the date on one occasion.

Thanks.

[June7]

Have to run an UPDATE sql action to populate field in table. If you don't want to save the value into table and just display date with each record, what you have should work as long as the form is open. If you want to provide db for analysis, follow isntructions at bottom of my post.