Data not showing in form

[Tumby]

I have a form with several date calculation.
As follows:
ContractStart- manually entered
ExpiryDate - Selected from a calendar according to the contract time
ReferBackDate - = DateAdd ("d", -180,[ExpiryDate])
ProposedNewStartDate - = DateAdd ("d",+1,[ExpiryDate])

All work fine except the ReferBackDate doesn't show up in the box unless you click on it and then on exiting the form it disappears until clicked again.

All properties look the same for each calculated date.

What could cause this.

Any help would be appreciated.

 

[PNGBill]

Any Unbound control will not store the data when you close the form.

Can you add a Refresh line to the AfterUpdate event on the ExpiryDate control box.

 

[Tumby]

Thanks for that but I don't know how to do that. Does code need to be written for the AfterUpdate event? I can't write vb.

 

[PNGBill]

You can make a Refresh Button from your Tool Box Command Button with assistance from the Wizard.

There will be one line of code that does the job. Copy this code into the After Update Event of the Text Box Control ExpiryDate.

To do this, right click on the Control - Text Box, and click on the Event Property for After Update. You should see 3 dots. Click on this and then click on Code.

A screen with some code will appear. This where you will past your line copied from the Refresh button. Past between the two line of code.