jatfill
Registered User.
- Local time
- Today, 10:33
- Joined
- Jun 4, 2001
- Messages
- 150
ok, after four hours I got the first part of this to work... but now it's driving me nuts
I have a form that has three combo boxes; the selection made by the user in box1 determines what is available in boxes 2 and 3. This works with no problem, I added the requery option so if they changed the selection in box 1, 2 and 3 would do a requery.
The problem is, when I run the form as continuous records , after you add record 1 and proceed to record 2, it resets boxes 1 and 2 on record 1 and record 2, so the previous selections on record 1 disappear. I thought Access recognized a control specification as the active control... is there any way to fix this? Thanks!
I have a form that has three combo boxes; the selection made by the user in box1 determines what is available in boxes 2 and 3. This works with no problem, I added the requery option so if they changed the selection in box 1, 2 and 3 would do a requery.
The problem is, when I run the form as continuous records , after you add record 1 and proceed to record 2, it resets boxes 1 and 2 on record 1 and record 2, so the previous selections on record 1 disappear. I thought Access recognized a control specification as the active control... is there any way to fix this? Thanks!