Calculated date field on form needs to populate field in table. 1

[monkeysee]

I have a field on a form named: Expiration date. This field is calculated from the Field: Issue date using the after update function.

What I would like to do now is, to have the date from the Expiration date field populate the Expiration Date field in the underlying table. More than likely, the after update function should be used again for this field. But am at a loss as to how to get it to do it.

 

[PHV]

Why your Expiration date control is not bound to the Expiration date field ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[monkeysee]

It is, but is not being updated.

 

[PHV]

It is, but is not being updated
Really ?
What is the value of the ControlSource property of your Expiration date control ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[monkeysee]

Expiration Date value: =DateAdd("yyyy",1,[IssueDate])

 

[PHV]

So, your control IS NOT BOUND to the underlaying table's field !
Bind it and do the calculation in the AfterUpdate event procedure of IssueDate.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[monkeysee]

Here's a star! You were right! everything works now, thanks again

 

[lespaul]

PHV is always right....I don't think I've EVER seen him post something that didn't work first try!


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins