Save Current Value to table

[Jess12 via AccessMonster.com]

Hi,

I'm trying to find a way to store the most current value to a new record. I
have a table with all the clients insurance info. We need to store the
current insurance info for each claim. How can i store the value of the
current insurance at the time of each claim?

Thanks
Jessie

 

[Beetle]

Hard to be specific without more details, but presumably your
Policy table has fields like the following;

PolicyID
ClientID
PolicyNumber
IssueDate
ExpireDate

and your Claims table has, among other things, a ClaimDate field.

You could then use several methods (a combo box, VBA code, etc.) to
retrieve the appropriate policy where the ClaimDate falls between the
IssueDate and ExpireDate.

_________

Sean Bailey

 

[Jess12 via AccessMonster.com]

There is no ExpireDate we only have the date that the new insurance card was
given to us, there is no expiration date on the insurance card. When a
client gets a different kind of insurance they give us the new insurance card.


We need the program to automatically figure out what the most current
insurance is, which we are able to do. The problem that we're having is
getting the insurance type to be saved in the new record for each claim.
Since it is calculated we need to capture that information and save it to a
new record.

Hard to be specific without more details, but presumably your
Policy table has fields like the following;

PolicyID
ClientID
PolicyNumber
IssueDate
ExpireDate

and your Claims table has, among other things, a ClaimDate field.

You could then use several methods (a combo box, VBA code, etc.) to
retrieve the appropriate policy where the ClaimDate falls between the
IssueDate and ExpireDate.

_________

Sean Bailey

Hi,

[quoted text clipped - 6 lines]

Thanks
Jessie

 

[Jess12 via AccessMonster.com]

There is no ExpireDate we only have the date that the new insurance card was
given to us, there is no expiration date on the insurance card. When a
client gets a different kind of insurance they give us the new insurance card.


We need the program to automatically figure out what the most current
insurance is, which we are able to do. The problem that we're having is
getting the insurance type to be saved in the new record for each claim.
Since it is calculated we need to capture that information and save it to a
new record.

Hard to be specific without more details, but presumably your
Policy table has fields like the following;

PolicyID
ClientID
PolicyNumber
IssueDate
ExpireDate

and your Claims table has, among other things, a ClaimDate field.

You could then use several methods (a combo box, VBA code, etc.) to
retrieve the appropriate policy where the ClaimDate falls between the
IssueDate and ExpireDate.

_________

Sean Bailey

Hi,

[quoted text clipped - 6 lines]

Thanks
Jessie

 

[Jess12 via AccessMonster.com]

I forgot to mention that the insurance type field is being looked up on the
maser form and I would like to save that value to the current record that i'm
editing in the subform.

There is no ExpireDate we only have the date that the new insurance card was
given to us, there is no expiration date on the insurance card. When a
client gets a different kind of insurance they give us the new insurance card.

We need the program to automatically figure out what the most current
insurance is, which we are able to do. The problem that we're having is
getting the insurance type to be saved in the new record for each claim.
Since it is calculated we need to capture that information and save it to a
new record.

Hard to be specific without more details, but presumably your
Policy table has fields like the following;

[quoted text clipped - 20 lines]