displaying generated date in a form

S

Sleek

Currently I have a form with the following feilds; [purchase date] [warranty length] & [warranty expiration]

what i want to do is calculate the warranty expiration date using the purchase date and the warranty length.

SO

I set the default value of the warranty expiration field to:

=DateAdd("yyyy",[Warranty length],[Purchae Date])

and added a macro to warranty length, so that on change it will requery warranty expiration.

Currently, I get no result the field remains blank.

Suggestions???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

displaying generated date in a form 3
Text box contents not visible until exited 3
Copy previous record into form field 0
adding two date fields 1
looping thru a continous form 5
not display date in past 2
Need to Make Query Run Faster - SLQ? 3
Date question, check if date is before today 3

Top