Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Checkboxes Subfrom Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gabby Girl - 22 Oct 2005 19:00 GMT
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.
Peter De Baets - 22 Oct 2005 20:47 GMT
>I sure hope someone can help me with this.
>
[quoted text clipped - 8 lines]
>
>Thanks kindly in advance for any help you can give me.

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,

Signature

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

Gabby Girl - 22 Oct 2005 21:13 GMT
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.

> >I sure hope someone can help me with this.
> >
[quoted text clipped - 16 lines]
>
> Please reply if you need more details,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.