Connecting Tech Pros Worldwide Forums | Help | Site Map

Access 97 Subforms

Cameron
Guest
 
Posts: n/a
#1: Nov 13 '05
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
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Access 97 Subforms


Cameron wrote:[color=blue]
> 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.[/color]

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
Closed Thread