How do I reinstate a member?

R

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
 
J

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>
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I clear a form? 0
Creating a Search using a combo box and then creating a report. 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Renewing member database design question. 7
Extract data in rows (with line breaks) to form a table 0
How to Submit rows of a repeating table to a SharePoint list 1
Linking form information to specific tables 2
Searching Across Two Tables For A Record 3

Top