Recent content by tjones

I have a button on a form that opens and generates an attendance sheet report. That is working fine but I also need it to filter the list of names on the report to just the form for a specific activity (ActivityID) that is displaying when you click the button instead of all names for all...

Basically i have 2 main forms StudentInformation and ActivityInformation (not sure if tabs are considered main/sub where the two fields are above the subdatasheet-subactivitystudentpage) you select an activity to enroll a student in: the subform on the studentinfo (tab Activity Enrollment) as...

Re: Problems Filtering a subform [FIXED] to make an entry in subform1 (student info main form / activity enrollment subform) fill to subform2 (activity info main form / activity attendance subform) Ensure "ActivityID" is in both main form tables and link via relationships Enter "ActivityID"...

Glitch between main and subform filtering This is all working nicely: First I create the activities for the semester in the Activity Entry form And create the Participant record (if not already in the system) I then enroll each participant in activities for the semester. When you create a...

I forgot to say that information is being pulled with a query so when i try and put in two column widths i get an error.

How do you get a subform to show data words instead of the numbers for the combo box it represents.

I have a table that contains all the information for an activity. On the form enter the first four fields and have it filter table to narrow down the selection for Activity Name that meets the criteria entered in the first four fields. form has field names: cboSchoolID cboSessionID...

I think I was going about it wrong. I re-set the form so the first four fields (school, session, grade and core comp) was pulling from their respect reference tables and the made a query in just the ActivityName field to sort through the information in the School Activity table. But its not...

I was attempting to make a table that you entered the information into (like product or maybe order a or like the combination country/state/city) where you updated the information for the semester and them pulled it into the individual records according the the activity they took. does that...

Thank you so much. It may not be pulling correctly from the table but hopefully i can figure it out ... at least its pulling information now!

I changed as suggested from refSession to refSchoolActivities SELECT refSchoolActivity.SessionID, refSchoolActivity.Session FROM refSchoolActivity WHERE (((refSchoolActivity.[SessionID])=[Forms]![frmActivityTaken]![SchoolID])) ORDER BY refSchoolActivity.[SessionID]...

Can not get the cascading fields to work. When you select the Activity Taken cmdButton and then on School select "Lowell" you should have three Sessions (per the refSchoolActivity table) "CS Porter" should give you three and so should "Big Sky" and then narrow down to the Grade, component and...

I am extremely lost by what you are saying. i have added in the student form and table (minimal data only but it does have the student ID number). I can get a query Activities Taken to pull the data the way i need and filter depending on the criteria entered from the Compiled table but not...

I do have the student table(s) but was trying to get the activities working right first. With the activity tables filled with test data I tried out queries to make sure it was pulling correctly, i still have to enter the coding for the fields and ensure that it filters correctly. After a...

MarkK I think I figured out what you were saying, is this what you were think for the setup of the tables and linking? Then the cascading fields would all come off the SchoolActivity table correct? After studying your remarks and demo of the table setup above it finally sank in with the...