PDA

View Full Version : Option box feeding an option box...won't work!



mud2
11-13-2006, 10:26 PM
ACCESS !@#!@@#!@
Form 1 has an option box which opens several other forms. Suppose form 1's option choice opens Form 2. Form 2 Also has an option box. If I get to form 2 from form 1, then the option box in form 2 does not work. If I open form 2 directly, then the options in form 2 work!

I can "get around" this by using Pages..

OBP
11-14-2006, 03:53 AM
muds, as say you can't get an "Option Box" to work I am not sure whether you are trying to use an "Option Group" or a "List Box".
So I have produced the attached database with 3 forms and an autoexec macro. The 3 forms have both methods of switching between forms.
The VBA is in the Option Group and List Box "After Update" event procedure.

mud2
11-15-2006, 08:32 AM
OBP: Thanks! I "Think" I've found the problem: When returning to my original...first form, I opened it in "Read Only" mode! Should have been in edit mode....I returned to different forms without worrying(!) about the mode!...Here's egg on my face!