Query...DateAdd...Parameters

[AMC31]

I have a form that has two fields...Start Date and Verbal Due. Verbal date uses the DateAdd feature to make it seven days following the start date.

I need to run a report on "Verbal Due" dates and set a date parameter. However, when the date is calculated in the form and put in the verbal due field on the form it is not copying it in the table.

How can I keep the DateAdd feature on the data entry form, get it to register so I can complete my query with the date parameter?

I am sure it is something simple I am overlooking...but any help would be greatly appreciated.

Thanks

 

[dcx693]

You can reference the Verbal Due Date from your query once it's been entered on the form. In the criteria line of the QBE grid enter a formula like this:
[Forms]![yourFormName]![Verbal Due Date]

 

[AMC31]

I tried that, but I am still not getting the result. When I look at the table that is linked to that form the [verbaldue] field is bland.

It is completing the calculation, but not storing it on the table.

Any other advice?

 

[dcx693]

The easiest way to store a value to the table is to bind a field on a form to that field on the table.

Set the control source of the [verbal due date ] field on your form to the proper name of the field in the forms recordsource.

 

[AMC31]

OK Call me crazy...but it is not working. I have attached the form.

When "File Started" is checked the current date is automatically put into "Date File Started"...[VerbaDue] is 7 days after "Date File Started"...[NarrativeDue] is 14 days after file is started.

It is not saving it in the table, which I need to create a date parameter query.

Thanks for your help.