Help with Checkboxes

  • 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?
 
I think your worst problem will be with your requirement:
The keys must be organized in columns per building (As header columns)
That's not too hard in a (non-interactive) report, but if you want to
interact (check off the boxes), you'll need a form.
And forms don't do columns like that well...

Perhaps you could revisit your design?
 
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?
Click to expand...

If the users INSIST on this design (which sounds awkward to me), then
you are probably going to be stuck using a Form with unbound
checkboxes. You'll need VBA code (in the AfterUpdate event of each
checkbox, or in some other form event such as a button click) to open
a Recordset based on your table and update it appropriately.

What's your table structure?

John W. Vinson[MVP]
 
Back
Top