Recent content by planetjeff

Hello all, I have three tables: Events (with pk EventID), Adjudicators (with pk AdjudicatorID, and Assignments (with pk EventID,AdjudicatorID) which tracks a many-to-many relationship. Events can have many judges (adjudicators), and judges can judge many events. In my form for assigning events...

Thanks to fiddling around with this and your input, I figured it out! First, I created a public variable in the form: Option Compare Database Public selectedEventID As Long Then, on any particular event subform, if an entry is clicked, I added the following: Private Sub Form_Click()...

Hi, to be more specific, I have (minimally, to lessen confusion) 3 tables. One for Events (with pk EventID), one for Adjudicators (with pk AdjudicatorID), and one for Assignments which tracks a many-to-many relationship between the first two tables (with pk EventID,AdjudicatorID). I have a...

Hello all, I have a form showing judges and a subform showing a list of all the events the judge can, well, judge. I also have a couple buttons where I'd like to be able to work on the selected record in the subform and take those values to create a new record entry (or delete an existing...

Okay, I figured it out, albeit using a slightly different path. First I created the first query to show preferred events per AdjudicatorID: SELECT Theaters.TheaterID, Theaters.Name AS Theaters_Name, Events.EventID, Events.Name AS Events_Name, Events.Type AS Events_Type, Events.StartDate...

Oh, I guess I just suck at this... I am attempting to create the subform using the wizard, and the closest I get on the RecordSource is the following: SELECT [PreferredTypes].[Type] AS [PreferredTypes_Type], [Events].[Name], [Events].[Type] AS [Events_Type], [Events].[StartDate]...

So, basically, you're saying that I will need a nested subform? I did get the information I needed already in that manner, but I'd like to view it like one subform, not nested. Is there a way to change how it's viewed? jeff

I don't think that works, I might have not been very clear: Tables: Events (with fields EventID [pk], Name, Type, Start Date, End Date) Adjudicators (with fields AdjudicatorID [pk], Name, Address, etc.) PreferredTypes (with fields AdjudicatorID & Type both forming [pk]) The Adjudicators...

Problem is, I don't understand how! (just started using Access about a week ago...) The RecordSource of the first subform showing the types an adjudicator can judge just has "PreferredTypes". The RecordSource of the subform within this subform showing all shows that match these types has...

Best way I know how to describe it, sorry! I am tracking Events and Adjudicators (judges) - each event is of an event type, and each Adjudicator can judge a selection of these types. For example, judge1 may judge three types of events, whereas judge 2 may judge only one type. The events can...