change table data depending on a check box

C

CD Tom

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
 
K

Klatuu

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.
 
C

CD 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
 
N

NKTower

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.
:)
 
C

CD 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.
 
K

Klatuu

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.
 
C

CD 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?
 
K

Klatuu

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.
 
Top