Help with a continous form

[chrisd49]

Hi All
I posted this earlier but don't think I explained it that well, so here goes.

I have a main form which displays a site name, city, post code.
I have 6 tabbed subforms which display a full record set of site name, address, contacts and telephone numbers for a client, site and other related data such as visits to sites and contract agreements.

I would like the main form to have a scrollable list of all the sites entered which will change the subforms to show the relevant detail for the first site in the list on the main form.

It works fine as a single form, I can use the record selector to find a site and all the relevant details change as expected.

I cannot change the main form to continuous as I get a message telling me I cant have this due to the subforms.

Is there a solution to this?

I'm fairly new to Access but can work my way through most things.
I'm using Access 2000.

Thanks

ChrisD

 

[PeterF]

The way to do this is to move the tabbed subforms to the forms footer and place the site list in the detail section. The tabbed form will reflect the data from the current record in the detail section.
After designing the form this way you can set the form continuous after it's been saved as a single form.

 

[chrisd49]

Hi Peter
I tried this and it didn't work. I ended up only seeing the sub forms in the tabs.
The main form has been created by the wizard using records from two tables, would this make any difference?
Thanks for your reply.
ChrisD