How do I reinstate a member?

[Robin Chapple]

I have a membership form with a sub form bound to the history table.

We record termination dates to exclude past members from the active
list.

I have a form of members terminated based on the "DateTerminated"
field as "Not Null'

I need to open the "MembersTerminated" form and force a new entry
into the history table.

How do I do that?

Thanks,

Robin Chapple

 

[Jeff Boyce]

Robin

One-time or a new function?

One-time -- open the table and make the change.

New function -- I'm not too clear on your data structure, nor on how your
forms are related to your tables.

More info, please...

Jeff Boyce
<Access MVP>

 

[Guest]

Is the member being re-instated or becoming a new member again?

If a new member again they get a new entry with new membership number.

If re-instated membership then do as Jeff says.