problems with subforms

[wprecht]

I need a form with 2 subforms. the main form is for an indidual. the first subform is a list of characteristics. the second subform is sort of a calendar function, produced for date scheduled, results, next meeting date.

I have tried the form wizard, but it produces a jumble of the mixed fields. Can I create a subform or 2 before I create the main form, and then link them somehow?[

I appreciate any advice,

Ted

 

[MartynE]

Just design a new form that will be one of your subforms, and use that form on the mainform as a subform. Look in the workset there is a option for that.

 

[wprecht]

I see no "subform" option under Forms Wizard in A2010.

When I create a form for Charges, it saves all right. When I open the Case form under
Design mode, I can drag the Charge form onto it, but the forms are not linked. I need the Charge form to be in a 1-to-many subform to the Case form.

Also, I do not know what a "workset" is.

 

[MartynE]

I will look into this on monday, I don't have any sparetime this weekend. Sorry!

 

[MartynE]

Can you provide me a sample database in Access 2003 format with the forms in question?

 

[Pat Hartman]

Usually (but not always) Access can figure out how a subform should be linked to the main form. You can override this by clicking on the subform control to select it and then on its property sheet data tab - change the master/child link fields.

 

[Simon_MT]

Perhaps if you tried bottom-up approach:

Creating two queries one form characteristics and Dates and Events. Test to see if you have the correct information and sort them according to your requirements.

Then create Continuous Forms from these queries. Again checking content. and then add these forms to your Parent forms with the correct Parent / Child.

Simon