468,296 Members | 1,306 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,296 developers. It's quick & easy.

creating check boxes at run time?

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

Similar topics

4 posts views Thread by Altramagnus | last post: by
2 posts views Thread by Iain Miller | last post: by
2 posts views Thread by Yoshitha | last post: by
3 posts views Thread by Search & You Will Find | last post: by
11 posts views Thread by Patrick | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.