Subform Help

[OZmc]

I have a main form that has multiple subforms from different tables. In the main body of the form I have a SET of subforms that I would like to display a diffiernt record each.

ie. instead of of cycleing through the records they are all displayed at the same time on one form. Bassically i want a continious form but my form contains subforms so it isnt possible.

I attached a picture of what I ahve so far. Note that the two subforms in the main body display the same record. is it possible to set one to something like record + 1?

 

[PaulO]

Sounds like you have two subforms displaying the same data, whereas you want to see all sequential records ... in which case you don't need subforms just a main 'continuous' form with stacked data as in your current setup.

 

[OZmc]

I can't have a continious form placed in a form that already has a subform in it.

my goal is to have a form setup like this:

Main form
-subform(1)
-subform(2) <--- idealy this would be my continous form
---subform(a)

Subform 2 could be setup with a button to just cycle through the records one by one but is it possible to use coppies of subform2 and VBA coding to display all the records at once?

Main form
-subform(1)
-subform(2) <--set to first record
---subform(a)

-subform(2) <--set to secodn record
---subform(a)

-subform(2) <--set to third record
---subform(a)
...

 

[OZmc]

*bump sorry, ill only bump the message once.

 

[PaulO]

I can't have a continious form placed in a form that already has a subform in it.
So, remove it?

If you're able to upload a zipped copy of your database this might enable greater clarity?

 

[OZmc]

the main form that is giving me issues is the daily records form. any suggestions / tips are appreciated.