Copy to another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one table (contacts) that contains information of people before they
apply to a program. I have a second table (Applicants) that will contain the
same information in the contacts table, but only if they have applied. Is
there a way I can create a macro to run off of a form to automatically copy
the record being viewed to the Applicants table?

Thanks,
Kevin
 
have you considered using just one table for "people", and adding a Yes/No
field named Applied, where Yes = person has applied. or perhaps a Date/Time
field, named ApplicationDate, where the Date or Date and Time is entered
only when the person applies? or you could even use a Status field instead,
so when a person's data is initially entered in the table the status of the
record is Contact - and when that person actually applies, the status is
changed to Applicant.

any of the above fields would be very easy to query against, to return all
persons who are contacts, or all persons who are applicants.

hth
 

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 to Populate Data from a table to another 0
Search one table to copy and paste select data to another table 1
Cutting a record from one table and moving it to another 2
How to export table from outlook into ms access table? 0
VBA - retrieve data on last create named range from previous inserted named range 0
vba to Insert records into a table for each record in another tabl 1
Access Sorting and grouping using multiple tables 0
Adding data to table that retreives data from another table 2

Back
Top