I have used similar code before in Access2000 but I am running into a "Method or Data Member not Found" error when I use the code in Access97. Based on what the user enteres into the catalogue field only those modules pertaining to the selected catalogue would show up in the module field.
Private Sub Module_GotFocus()
Dim strSQL As String
strSQL = "SELECT Module" & _
"FROM tbl_Catalogue_Modules WHERE Catalogue= '" & Me![Catalogue] & "'"
Module.RowSource = strSQL