One-to-many data in a continuous form: ways around this?

[WesHarding]

Hi All,

I currently have a database that works to search through farmer records based upon typed parameters by the user (name, etc.). Each record in this continuous form has a "Detail" button which redirects the user to a form containing further information such as commodities. However, my boss keeps insisting that I put commodities on the initial record.

These commodities are are-to-many, as one farm can produce many things. I know from the past that I had zero luck getting a subform into a continuous form. So I am curious if anyone has tried tackling the issue of populating a continuous form with one-to-many data. Any advice would be greatly appreciated, as I don't really know how I'm going to handle this predicament.

[ranman256]

you CANNOT put sub forms in a continous form.
Your design is correct, pick from the list (continous) goto Detail.
Add subForm items in the single record detail form.

Managers and VPs always want to do things bass-akwards.

[WesHarding]

I actually really like the way I have this designed too! It all comes back to their desires to see it "in an excel spread sheet"... Oh well. I'll re-confirm this information. Thank you ranman256

[Missinglinq]

you CANNOT put sub forms in a continous form.

Sure you can...you just have to fool the Access Gnomes!

The workaround for having a Subform when the Main Form is in Continuous View requires that you put the Subform either in the Header or the Footer of your Main Form. To escape the wrath of the Access Gnomes you have to:

• Create your Main Form in Single Form View
• Place the Subform in Header or Footer, whichever you like
• Save the Form
• Now go into Properties and change the Main Form's Default View to Continuous View

Linq ;0)>