Subform question please

[hmho]

I have main form and subform is it possible to have them side by side instead of at the bottom of each other. there is about 50 lines for the form and I want to be able to see all of them on the screen. I'm new to access so I'm not even sure if this makes sense.

Thanks

 

[pbaldy]

The subform could be anywhere within the main form. You should be able to place it at the side.

 

[hmho]

But I want to see the main form as continuous form and the subform as datasheet.

 

[pbaldy]

Can't be done. You could use 2 subforms within a main form.

 

[hmho]

Do you have any other suggestion basicaly this is form I will enter each day's phone card sales and it has thses fields (SerialNo, GameNo, EndingNo, SalesDate). There are about 50 diffrent typens for every day's sales. What I like to see is all cards yesterday's sales whit all the fields and i want to enter today's ending, but the reason I want to see yeterday's ending is so i don't miss any cards that was active yesterday even when they are sold out I want to enter ending number as the max number.

 

[pbaldy]

You could use a listbox to display the previous day.

 

[gemma-the-husky]

pauls first idea is good - use a container form, and then show both sub forms side by side

needs a little bit of code to manage links, as now its no longer a master/child - but otherwise looks and works just the same

basically in the master subform, set a variable in the current event - include this variable in the base query for the second form - but you will also have to do secondsubform.requery in the first subform current event.