> 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.<<
