- Joined
- Nov 8, 2006
- Messages
- 3
- Reaction score
- 0
Hiya,
I have a database where I have to drill down on a large code AA00AB01AA00 etc. I have broken this down into ten parts eg
qrySTAGE1
1ID - Info
AA - AA
qrySTAGE2
2ID - Info - 1ID
00 - 00 - AA
Then I have used forms and subforms so the user can drill down to the code they are after.
AA -> AA00 = open record AA00.
However Access only seems to be drilling down to the seventh sub form when I need it to go to ten.
Has anyone else encountered this and/or is there a way around it?
Cheers.
I have a database where I have to drill down on a large code AA00AB01AA00 etc. I have broken this down into ten parts eg
qrySTAGE1
1ID - Info
AA - AA
qrySTAGE2
2ID - Info - 1ID
00 - 00 - AA
Then I have used forms and subforms so the user can drill down to the code they are after.
AA -> AA00 = open record AA00.
However Access only seems to be drilling down to the seventh sub form when I need it to go to ten.
Has anyone else encountered this and/or is there a way around it?
Cheers.