 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2007change table data depending on a check box
Ok, here's what I want to do. In a setup table I have different options that the user can check Yes/No, there is a Events table that has all the events entered. When a user checks one or more of the options in the setup table I want only certain Events to show up in the events table drop down list. Example party 1 is checked and party 2 is checked, in the events table all events are entered party 1-1 party 1-2 party 1-3 party 2-1 party 2-2 party 3-1 party 3-2 etc. With party 1 and party 2 checked I only want the party 1 and the party 2 events to show up in the drop list. What would be the best way to handle this. I hope my explanation is clear enough to get an answer. Thanks for all your help. Tom CD, I got lost in your explanation, but I think from what I did understand is that you need to filter your combo based on the setup table. Re reading my answer, it is a least as confusing as the question :) Post back a bit more detail and maybe we can get it done.  SignatureDave Hargis, Microsoft Access MVP > Ok, here's what I want to do. In a setup table I have different options that > the user can check Yes/No, there is a Events table that has all the events [quoted text clipped - 8 lines] > > Tom Great to hear from you. I'll try and explain a little better. The user has a setup that they will go into, in the setup they have some options like I said earlier Option 1 Party 1, Option 2 Party 1-2, Option 3 Party 2, Option 4 Party 2-1. Each of these options has a check box associated with it. Say the user checks Option 1 and Option 2. When they go into the registration form to register a person I want the registration drop down box to only show the two options that the person has to register this person. The registration person would click the registration drop downl list and have Party 1 and Party 1-2 listed option 3 and option 4 would not show up. I'm trying to make it so the registration person will only have the options that have been check in the setup and not be confused with all the options in the events table. I hope this makes a little more sense if not let me know and I'll try again. Are you still doing SASS? CD > CD, > [quoted text clipped - 16 lines] > > > > Tom Let's take apart your naming convention, and maybe make up an example. Maybe that will help. I'm making a wild guess that X-Y mean party X, and option Y? Party 1 may be "child's birthday party", and option 1 may be CAKE, option 2 PIZZA, option 3 ICE CREAM, and option 4 CLOWN etc? If so, then 1-1, 1-3, 1-4 means that the person elected to have a "child's birthday party" and it will include CAKE, ICE CREAM and a CLOWN - because said options 1,3 and 4 correspond to the checked boxes? If so - to start with, I'd break the X-Y into two separate database table columns - first is link_PartyType, and the second is link_OptionType. But before I/we re-design everything, let's make sure we understand the problem. :-) > Great to hear from you. I'll try and explain a little better. The user has > a setup that they will go into, in the setup they have some options like I [quoted text clipped - 32 lines] > > > > > > Tom I've been playing with this and have finally come up with a way to do what I want. It's probably not the best way but it works. Basically I change the row source for each combination, there wasn't that many so it isn't to hard to understand. Anyway thanks for your help. > Let's take apart your naming convention, and maybe make up an example. Maybe > that will help. I'm making a wild guess that X-Y mean party X, and option [quoted text clipped - 46 lines] > > > > > > > > Tom Hey Tom, I think changing the row source is probably the best option. Yep, still doing SASS, you? Is this app the SASS app? I was wondering if that was your product. SignatureDave Hargis, Microsoft Access MVP > I've been playing with this and have finally come up with a way to do what I > want. It's probably not the best way but it works. Basically I change the [quoted text clipped - 51 lines] > > > > > > > > > > Tom Yes still do SASS have gone to the dark side. This isn't the SASS apps, but yes that's mine. It seems to be doing quite well, we have it in about 150 clubs and everybody like it. I do have another question, if you would be willing to give it a try. I have labels in a setup form that I want the user to be able to change, that I can do. What I want is to have that label used on a report. Is there a way in a reports event to get that label from a closed form. By the way do you ever get a chance to go to the Convention in Vegas? > Hey Tom, > [quoted text clipped - 58 lines] > > > > > > > > > > > > Tom I would love to make the convention, but it is not in the budget. You can't get it from an closed form, but you open the form hidded in design view then copy the caption of the label. I ran a quick test in the immediate window and here is the results: docmd.OpenForm "frmUpdate",acDesign,,,,acHidden x = forms!frmupdate!txtver.caption ?x Installing new version docmd.Close acForm,"frmupdate",acSaveNo I would try doing it in the report's open event. SignatureDave Hargis, Microsoft Access MVP > Yes still do SASS have gone to the dark side. This isn't the SASS apps, but > yes that's mine. It seems to be doing quite well, we have it in about 150 [quoted text clipped - 67 lines] > > > > > > > > > > > > > > Tom |
Reply to this Message |
 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.