how to update table based on option button selelction

[an88]

hi i am new to ms access and i want to develop an ms access application that contains three tables namely quarantine_table,released_table and rejected_table and i created a form called Frm_Sample that takes samples from quarantine_table. within that table i have created an option buttons rejected and released, now i want to update the table rejected_table and released_table from quarantine_table based on the selection of the option buttons. how can i do this plz someone help!

[twinnyfo]

an88,

Welcome to Bytes!

I think I might have an idea as to what you are trying to do, but I am not certain. Thus, I can't give you any specific guidance to this problem other than to ask you to clarify what it is that you want to do.

Understanding the nature of your DB, what your three tables are trying to capture (as well as a bit of information on what data they contain) is a great place to start.

Finally, this forum doesn't usually work solutions for its posters. We much more prefer that the posters have tried something first and put in a genuine effort toward a solution. Upon failure of those efforts, we are glad to troubleshoot. So, what have you tried so far? How has your solution come up short?

Sorry that this is not a "solution", but without additional information, we would be aiming while blindfolded at a target in the dark behind a veil.

Hope this hepps!

[NeoPa]

It sounds very much like you need only one table with a field to indicate the stage each record is at - Quarantined; Released & Rejected.

[twinnyfo]

NeoPa,

My initial thoughts exactly -- but we need more info!!!

Remember all those years back when you convinced me to go to a one-table system instead of two?

;-)

[NeoPa]

Hardly. You've come on so far and so fast my old brain cells can't imagine you needing such help :-D