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

creating check boxes at run time?

P: n/a
I am creating a system whereby equipment is inspected. Data is
inputted into an inspection form. However, any equipment that is not
satisfactory needs to have spare parts ordered for that piece of
equipment from a list of parts. I kind of need a form which lists
parts and then check boxes next to a part can be created so the user
can select which parts are needed and then a button is clicked which
sends these parts to a report. I am not sure how to go about doing
this. I have been told that perhaps dynamically creating the check
boxes at run time may be a possibility. How could this be done?

Any suggestions would be much appreciated.

James
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> I am creating a system whereby equipment is inspected. Data is
inputted into an inspection form. However, any equipment that is not
satisfactory needs to have spare parts ordered for that piece of
equipment from a list of parts. I kind of need a form which lists
parts and then check boxes next to a part can be created so the user
can select which parts are needed and then a button is clicked which
sends these parts to a report. I am not sure how to go about doing
this. I have been told that perhaps dynamically creating the check
boxes at run time may be a possibility. How could this be done?


You need to add a boolean field to a table to which you could bind your checkbox
(you cannot *dynamically create* a control in Access), that field's purpose
being to act as a flag for your reporting. Whether this field is added to the
"Parts" table or a separate table in the application file with the sole purpose
of flagging these parts depends on whether this is a multi-user application
(split, of course!) or not and whether there would ever be a problematic
conflict if it were. You would need to provide your checkbox on the form at
design-time, and bound to that boolean field, to allow the user to check off the
required parts setting the flag to True to satisfy a criteria in your report's
recordsource and, after running your report you could simply run an update query
to set the flag in all the records back to "False". Hopefully, these "parts" are
in a separate table and not simply fields contained within a single table.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.