Recent content by DDivney

I'm making a database where students can earn 'merits' in three different ways, either by playing sports, participating in events, or academically. The academic merit count is a field on the Student table, as it is edited directly by a form. The event and sport merits are calculated from the...

That worked very well, thank you! I'm still learning on the fly, which is quite awful really... What do the inverted commas denote then?

I'm trying to make a cascading combo box, but the afterupdate event that updates the rowsource of the other combo box throws up this error. Basically, I have two fields, TournamentID and Home (as in home team). The rowsource for the TournamentID combo box is as follows SELECT...

So quickly checking, what you did was add a WHERE clause to the Rowsource, and a requery whenever the subform got focus?

Incredible! Thank you so much!

Something broke in the conversion, but I don't think it was anything too essential.

Right, sorry. I'm making a form that creates a new team. Details for the team include the Name, the House (as in Harry Potter), the activity or sport, the tournament, and the gender. The actual team table has a many to many relationship with the student table via a junction table, which is a...

Thanks for the answer! I'd seen that, but it never seems to work for me. Here is the code I'm trying to run: Private Sub HouseID_AfterUpdate() Me.Filter = "Me!Student_Team_sub.Form.StudentID.Column(4) = '" & Me!HouseID & "'" Me.FilterOn = True End Sub It just tells me there's an...

I'm trying to filter a combo box in a subform, and I almost have it, but I'm having some trouble referencing the subform combo box (access keeps asking me for a parameter value). My problem is that the value I need is one of many in the combo box (It's a lookup field) (here is its rowsource...

It's ok, I just figured it out! Apparently, I had just been missing a few spaces in the afterupdate code, which combined with some bad referencing killed the form. Well, at least now I know... Thanks for the help though!

So I finally got the hang of cascading combo boxes, only to realize that they don't work on my form for some reason. Basically, I have three tables. One for sports, one for tournaments, and one for teams. Each table is linked with a lookup field to the other (i.e. each team has a tournament...

Hey! I'm Daniel, and currently reside in Costa Rica. I'm wrapping up my International Baccalaureate (should be done in november) and have to say I'm not the best at access, but I'll definitely need to use it in the future.