Multiple Check boxes on a form

  • Thread starter Thread starter Angel
  • Start date Start date
A

Angel

I need to build a Key database. The Db needs to contain all keys available
per building (5 buildings). Somehow I need to display the keys in a form
with the keyname and a check box next to it. The keys must be organized in
columns per building (As header columns) My plan is to select a user and
then from the available keys just place a check mark next to key assigned to
the user. Also the form needs to display which keys are assigned to the user
in case the user was assigned keys before. Can some one get me started on
something like this?
Thnak you very much!
 
Angel,

May I suggest an alternative model? Whereas what you are suggesting is
possible, it seems like a lot of stuff on the form, where only a very
small proportion of what's on the form would be used at any given time,
if you see what I mean. I would prefer to have a form for the User, and
then a continuous view form for the Key Assignments. And this would go
onto the User form as a subform. I would envisage this suform to
consist of 2 comboboxes. In the first combobox, you would select the
Building. And then, the second combobox would list all unassigned keys
for the selected building. And as a result, the subform would end up
showing any keys assigned to that User. This is the user interfac for
managing the assignment of keys to users. You would, of course, also
need another form for the keys themselves. And you could always have a
form or report where you could see an overview of all keys and who they
were assigned to. Would this kind of concept work for you?
 
Back
Top