Move Record to different table in access

B

BMBerna

I need to be able to take a record and move it to a different table
using a combobox. I have a combobox called CboAgencyStatus in
frmConsumers when the option discharged is selected I need the record
to move to tbldischarged. Is there away that this can be done? I
thought of using a checkbox but i need to use a combobox due to other
options with in the box. Other information that may be important is
frmdischarge, tblconsumers. I thought of using an append query but I
don't think that is what i need. Not sure if this will work either.
 
W

Wayne-I-M

Hi

It sounds to me as if you have 2 tables that are virtualy the same ?
(tbldischarged & tblconsumers)

If so you could combine the date in the tables and add another field
(discharged = Yes / No)

Must be a better way I think - but there may be another reason why you are
using 2 tables ?? if so can you post details
 
B

BMBerna

Hi

It sounds to me as if you have 2 tables that are virtualy the same ?
(tbldischarged & tblconsumers)

If so you could combine the date in the tables and add another field
(discharged = Yes / No)

Must be a better way I think - but there may be another reason why you are
using 2 tables ??  if so can you post details

--
Wayne
Manchester, England.





- Show quoted text -
Click to expand...

I wanted to do a checkbox but I am unable to do that due to certain
certeria in the combobox. So is there away to do this with a combobox?
 
Top