Search results

Hi paul, Thanks. Sorry about 'reminder' but i am trying to get this working for 2 days now and can't believe there are not more tutorials or a downloadable files online from Microsoft themselves showing how this technique is done. As a novice, it is very fustrating getting so far and then...

Any further help on this would be appreciated please folks

Thanks Paul - I'm still not having any luck after changing it to below: Me.CboCourse.RowSource = "SELECT Distinct Courses.Course FROM" & _ " Years INNER JOIN Courses INNER JOIN Locations INNER JOIN CHistory ON Locations.LocationID = CHistory.LocationID ON...

Thanks for reply. Yes, i have left it blank as i am not sure what to put in. I have tried everything in the afterupdate event but can't get anything working. I have tried something like the following but it is not working. Any direction would be great. "SELECT Distinct Courses.Course FROM" & _...

Hi Folks, Have managed to get two cascading dropdowns working but need three and can't get the third working. (see included file) The CHistory form will only used to view courses completed by employees. I hope to include a Subform on the CHistory form to show the employees when the third...

Hi Lagbolt - thanks for comments. i have attached my updated database with modified tables. I agree that my tables were a bit all over the place :) I would like to show a subform on the FRM.Employee showing the relevant courses employees have taken. I wish to filter the subform by selecting...

Hi Folks, Access Noobie here. Having great difficulty linking result from 2 DropDown selections to a Subform. I have Location, Employee and Courses Table. I have managed to get the two dependant dropdowns working so upon clicking the first Location option, the Employee Dropdown is then updated...