Access 97 Subforms

[Cameron]

I'm working on a project where we are modifying an access 97 database
to give a reporting aspect of it a easier to use look/feel.

Basically i have setup a 'wizard' sort of that will generate a report.

I am using a form with a subform in it and next/back buttons in the
main form to modify the SourceObject of the subform.

The problem that I am having is that my form elements (list boxes,
checkboxes etc) are not working correctly (Ie i cannot interact with
them at all, can't check boxes or anything) when displayed in the
subform.

Is there any problem with form elements in a subform in access97? I
would really like to use this technique as it makes things much
easier.

Any suggestions?

Thank you.

[Bas Cost Budde]

Cameron wrote:

I'm working on a project where we are modifying an access 97 database
to give a reporting aspect of it a easier to use look/feel.

Basically i have setup a 'wizard' sort of that will generate a report.

I am using a form with a subform in it and next/back buttons in the
main form to modify the SourceObject of the subform.

The problem that I am having is that my form elements (list boxes,
checkboxes etc) are not working correctly (Ie i cannot interact with
them at all, can't check boxes or anything) when displayed in the
subform.

If you refer to subform controls in code, you have to use the right,
somewhat cumbersome syntax:

Forms!yourform!subformcontrolname.Form!controlname

The Forms!yourform part can be skipped if the code executes from that
form, of course.
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea