To many access sub forms?

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.
 
Back
Top