3 replies
by jdg
If you are updating the table values using a defined Access form, there are several ways to auto-update a field's value based on a prior field. First is to use an "After Update" event program attached to the initial date field (by the way, "date" is NOT a valid field name in Access, since it is also a keyword). Here is a simple line of code that would update one date from another:
Me.txtCalcDate = Me.txtNewDate + 183
There are other ways, but this may be the simplest.
by sparkie_ig
okay..having worked in healthcare..managed care with suthorizations and terms of coverage etc...I came upon this one all the time.
you will create a formula for the expiers field.
it should read "183 + [table name.fieldname]
[tablename.date]
as long as you have the set up correct it works every time.
sparks
by sparkie_ig
okay..having worked in healthcare..managed care with suthorizations and terms of coverage etc...I came upon this one all the time.
you will create a formula for the expiers field.
it should read "183 + [table name.fieldname]
so using your info...
dont include this line merely to show you [tablename.date] + 183
as long as you have the set up correct it works every time.
sparks
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending