Forms - Date and £ $ Prefill

[kingston123]

I really need some help with Access and forms. I can send anyone the database if you need to see it. It is in Access 2002 and I am stuck on how to do a few things. I have screenshots that I can send of the form as well so you can see which boxes I am referring to.

I have put the Initial Input Date field in the form and this sets to the current date when the record is first added. This will not need to be changed.

When the record is first added using the form, I would like SCL Last Updated date to prefill to the Initial Input Date if the field is left blank (null). It has to be possible for the SCL Last Updated field to be manually overtyped at a later date if necessary.

The Next Review Date needs to be the SCL Last Updated plus 90 days. I can’t work out how to do this. This won’t need to be manually typed over.

Also the Reserving Policy Currency combo box on the form allows users to select either USD or GBP. Is it possible that if the Reserving Policy Currency equals GBP or USD that either a $ or £ come up in front of the amount that the person will input for the O/S Loss field?

I really appreciate any advice you can give.

 

[formerTexan]

kingston123,

On the After Update event of Initial_Input_Date control

If Len(Me.SCL_Last_Updated) then
    Me.SCL_Last_Updated = Me.Initial_Input_Date
end if

Change the control names for your situation.

Me.SCL_Last_Updated + 90 will get your Next Review Date

I suspect you can play with the formatting for the dollar/sterling swap, but perhaps someone else can offer specifics. Note that chr(163) is the sterling symbol.

Cheers, Bill