Checkboxes Subfrom Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sure hope someone can help me with this.

I have five checkboxes for phone accessories (ie: dc charger, ac charger
etc..) Currently I have it set so that when any of these are checked true
they bring up a hidden subform to record date given out and reason why. The
way it is right now, I have all these dates and reason but it doesn't tell
you which accessory it is on the subform. Is there a way to record the name
of the accessory automatically (re: which check box was clicked) next to the
date? Am I going about this the wrong way or is there a better way to handle
this?

Thanks kindly in advance for any help you can give me.
 
Gabby said:
I sure hope someone can help me with this.

I have five checkboxes for phone accessories (ie: dc charger, ac charger
etc..) Currently I have it set so that when any of these are checked true
they bring up a hidden subform to record date given out and reason why. The
way it is right now, I have all these dates and reason but it doesn't tell
you which accessory it is on the subform. Is there a way to record the name
of the accessory automatically (re: which check box was clicked) next to the
date? Am I going about this the wrong way or is there a better way to handle
this?

Thanks kindly in advance for any help you can give me.
Click to expand...

Just a suggestion: You might want to skip the check boxes and just have an
"AccessoryType" or "AccessoryName" field in your subform.

As an alternative, you could have the AfterUpdate event procedure of the
checkboxes update an "AccessoryType" field in your subform.

Please reply if you need more details,
 
Thanks for the reply Peter.

I agree with you in that I should just do away with the checkboxes, but
unfortunately the guy I'm designing the form for really wants them. Worse
comes to worse I'll just tell him it can't be done but I would really like to
explore all avenues just because I'm stubborn (LOL). Could you possibly give
me a bit more help on the After Update event for the checkbox? I have the
following fields on my subform (which is called fsubAccessories):

AccDate
Reason
AccType

I just can't figure out the code for the After Update event.

Again Thanks Kindly for the help.
 
Back
Top