Linking calculations in a form to a table

[Scott]

I have a table that includes a field called [Date Issued] and a field called [Expiry Date]. In my form I have a calculation that determines the [Expiry Date] from an input [Date Issued] using the DateAdd and IIf functions. However although the calcs work in the form - I can't get them to return the values to the table (the Date_Issued does return to the table). Any help would be appreciated

 

[mir_99]

Hi Scott!
you should write the code in the OnClick event of the 'Save' button (u should create on ur form).
The code should be like this:
yourRecordset.Edit
ME.[ExpiryDate].setfocus
yourRecordset.Fields("urExpiredateSno")= Me.[ExpireDate]
Me.[IssuedDate].Setfocus
yourRecordset.Fields("urDateIssuedSno")=Me.[IssuedDate]
yourRecordset.update

try it !!
hope it will work
imran

 

[Scott]

Imran - thanks for info but I don't know much about VB macros.

I've set up a text box on form called [Expiry Date] and a command for[save] - I then put in your routine into OnClick event, but it didn't work.

I'm assuming 'yourRecordset' is the name of my table [Permit Details] and 'Me' is the name of my form [Permit Details2]. Is 'urExpiredateSno' my DateAdd function?

I don't know what 'urDateIssuedSno' is meant to be!

An idiots guide would be appreciated.