Updating a date field in a record using a number field in that same record

[cpbittner]

Newbie. I have a set of records that I need to develop a way, perhaps a button on each record, that would call a method or macro that would take a number that is in one field of the record [frequency], and increment a date field [nextJobDate] by adding the [frequency] value to the [lastJob] date field, all of these fields are in the same record.



As a newbie, I need guidance on how to best start, I know the AddDate function should be used, but am not sure how to update a record field using that function by referencing another field which has the incremental value. Any good URLs I can reference would be greatly appreciated as well.

[June7]

Why save the calculated value? Just calculate when needed. What is the frequency unit (day, month, year)? If day don't need function, day is default when adding a value to a date. Otherwise use DateAdd function. Access Help has info.

[cpbittner]

The dates are recommendations but require occasional manual updates indicating when the job is actually done, or rescheduled. I will use VB to write code to make this change, I'll post further if I run into issues doing that.

[June7]

Yes, will require code to save calculated value. If the field is included in form RecordSource, could be as simple as:

Me!fieldname = Me.textboxname

The real trick is figuring out what event to put the code in.