By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,477 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Access 97 Subforms

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.