How to ensure subforms 1 OR 2 not 1 AND 2 write to table.

[JugglingGeese]

I have a slight problem in that I have some subforms based on an answer to a yes/no question.

They are visible/invisible based on this, and that is fine for first-passes, however, if a user changes their mind, they could potentially answer both yes and no since Access auto-dumps both answers to tables.

So what I want is if Y answered on higher level form:
subform 1 - open and usable, doesn't dump (or erases) on No answer
Subform 2 - open and usable, doesn't dump (or erases) on No answer

if N answered on higher level form:
subform 3 - open and usable, unusable and doesn't dump on Yes answer.

I have tried all kinds of tricks, including making "NO" a seperate form that opens, but that comes with it's own problems. Since the no form uses a double key field, it either leaves incorrect things blank, screams at you, or dumps the wrong things

I have tried creating an undo button, but this doesn't do what I need it to.

I have also tried deleting the record from the table once written, but this isn't sufficient (would have to erase more than one table) and also causes Access to crash.

If you want to know about this specific DB before answering, I posted a different (more general) question about it to this thread with a lot more detail:

http://www.tek-tips.com/viewthread.cfm?qid=1531287&page=1

(posted 17 feb 09 in MS Access Other Topics)

Please help. I am becoming very frustrated

 

[MichaelRed]

in concept only load ONE of the subs. If User changes their mind, Reload.

In general, have ONE sub whose source is either sub 1 or sub 2. If these are 'radio' buttons, you could have three options (0 = none, default), 1 = sub 1, 2= sub 2). Selection of 1 or 2 would change the source of you sub to the selected (sub 1, or Sub 2) and requery the main?




MichaelRed