By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,636 Members | 1,941 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,636 IT Pros & Developers. It's quick & easy.

how to update table based on option button selelction

P: 1
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!
Apr 3 '19 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 2.5K+
P: 3,282

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!
Apr 3 '19 #2

Expert Mod 15k+
P: 31,487
It sounds very much like you need only one table with a field to indicate the stage each record is at - Quarantined; Released & Rejected.
Apr 4 '19 #3

Expert Mod 2.5K+
P: 3,282

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?

Apr 4 '19 #4

Expert Mod 15k+
P: 31,487
Hardly. You've come on so far and so fast my old brain cells can't imagine you needing such help :-D
Apr 4 '19 #5

Post your reply

Sign in to post your reply or Sign up for a free account.